Copy/paste without clipboard "Object required" ?

[SnakZ]

Windows 7 excel 2007
Im real new at VBA (but do know some PHP if that helps lol)

ANYWAY a website had a way to copy and past without using the clipboard link here: "Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros"

Sub Testing()
Sheet1.Range("A1").Copy Destination:=Sheet2.Range("B1")

End Sub

When i use this code i get an "Object required" and if i use "Option Explicit" i get "Variable not defined"

Only thing i can think of is i need to use a "Set" or "Dim" of some type at the top but that where im lost at lol

If i use it on the same sheet there no errors

Ty for any help one can give

 

[RoryA]

Is the code located in the workbook that contains those two sheets?

 

[SnakZ]

Is the code located in the workbook that contains those two sheets?

No all the code was saved on the "Personal.xlsb" workbook they was not saved inside the workbooks i was using it in.
You think thats what did it ?

 

[RoryA]

Yes - you can't use sheet codenames across workbooks unless you set a VB reference between the two projects.