debauch
08-03-2007, 06:21 AM
Hello,
We have a tool that removes formula from each workbook we select, and it works great in 97. When we upgraded to 2003 though, we are not able to use the same code. Below is where it errors out (on ws.cells.select)
The message says "Object does not support Method or Object".
For Each ws In ActiveWorkbook.Sheets
ws.Activate
ws.Cells.Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Next
There is a line that is no longer support in 2003 in here you think?
We have a tool that removes formula from each workbook we select, and it works great in 97. When we upgraded to 2003 though, we are not able to use the same code. Below is where it errors out (on ws.cells.select)
The message says "Object does not support Method or Object".
For Each ws In ActiveWorkbook.Sheets
ws.Activate
ws.Cells.Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Next
There is a line that is no longer support in 2003 in here you think?