On Feb 16, 3:40*pm, jaxgab wrote:
I have used code like the following for many years to remove all the
formulas from multiple worksheets.

Sub Convert2Values()
* * Sheets(Array("Cover", "Comments", "Month", "YTD", "Analysis",
"Cost Per Car")). _
* * * * Select
* * Sheets("Cover").Activate
* * Cells.Select
* * Selection.Copy
* * Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
* * * * :=False, Transpose:=False
End Sub

The code still works as a stand-alone macro. *However, when I place
the place the code into another Excel macro, it will only convert the
first page ("Cover") to values.

Do anyone have any ideas what is going on? *I was previously using
Excel 2003 and the code worked fine.

I bet you wish Lotus 3 DOS was still around - you could address the
"cube" directly and Clear it or Copy to it.

Excel is a pizza menu, whereas Lotus DOS was the Encyclopaedia
Britannica :)