Cut Method

[Greg Zadacha]

Hi,

I am trying to move some formulas onto a new sheet.

My code below does not work for some reason. Something wrong with the
destination range.
Using Xl 97 on Windows NT 4.0.


'**********************************
ActiveWorkbook.Sheets.Add
ActiveWorkbook.Sheets(1).Range("EA1:GM183").Cut _
Destination:=ActiveWorkbook.Sheet(2).Range("A1")
'**********************************

Thank you in advance for your help!
Greg

 

[Tom Ogilvy]

Destination:=ActiveWorkbook.Sheet(2).Range("A1")

shouild be

Destination:=ActiveWorkbook.Sheets(2).Range("A1")

Add an "s" to Sheet