My workbook contains 78 project worksheets. I have a summery page I am trying to email using Rons Mail one sheet script: http://www.rondebruin.nl/win/s1/outlook/amail2.htm
The past as values has been uncommitted in the code.
It works for everything except the Indirect formulas end up #ref !.
My Summery Page Layout:
Column A67:A145 contains a list of worksheets.
Column B67:T145 contains INDIRECT($A67&"!AC$49") to pull data from the worksheets. The AC49 changes for every column.
Should I use a different formula to pull the data into my summery page, or a different email script. The workbook is used by multiple people across the country some with limited computer skills. I'm looking for a one click email active worksheet as values option.
The past as values has been uncommitted in the code.
Code:
[COLOR=black]'Change all cells in the worksheet to values if you want[/COLOR][COLOR=black]
With Destwb.Sheets(1).UsedRange
.Cells.Copy
.Cells.PasteSpecial xlPasteValues
.Cells(1).Select
End With
[/COLOR][COLOR=black] Application.CutCopyMode = False
[/COLOR]It works for everything except the Indirect formulas end up #ref !.
My Summery Page Layout:
Column A67:A145 contains a list of worksheets.
Column B67:T145 contains INDIRECT($A67&"!AC$49") to pull data from the worksheets. The AC49 changes for every column.
Should I use a different formula to pull the data into my summery page, or a different email script. The workbook is used by multiple people across the country some with limited computer skills. I'm looking for a one click email active worksheet as values option.
