Runtime error 91 help
Hi Hachiroku,
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 5/15/2006 by CHEUANDK
'
' Keyboard Shortcut: Ctrl+s
'
dim curBook as workbook
set curBook = activeworkbook
Range("E3:E4000").Select
Selection.Copy
Windows("PERSONAL.XLS").Activate
Windows("Large Amount Report By ARM Templete.xls").Activate
Range("A10").Select
ActiveSheet.Paste
curBook.Activate
Range("D3:D4000").Select
Selection.Copy
Windows("Large Amount Report By ARM Templete.xls").Activate
Range("B10").Select
ActiveSheet.Paste
curBook.Activate
Range("H3:I4000").Select
Selection.Copy
Windows("Large Amount Report By ARM Templete.xls").Activate
Range("C10").Select
ActiveSheet.Paste
End Sub
You dimensioned curBook as workbook (which is object) and tried to
assign it value activeworkbook.name (which is string) and didn't set
the object to the variable.
Regards,
Ivan
|