I meant to add (ok ok, rookie poster error lol) that the active sheet is sheet1
Ok, so why does this work...
and this does not...![]()
Sheets("Sheet2").Range("A1") = "ccc"
Greg, thanks for the tip, fixed the )![]()
Sheets("Sheet2").Range(Cells(2, 2), Cells(4, 4)) = 50
As far as using .value, I changed to "aa" and it still didn't work
The only difference is that I used a different reference method
I get an error saying "application defined or Object defined error"
Bookmarks