I am trying to figure out how to copy a dynamic range on another sheet to paste into the current sheet. The range would be cell A1 and extended to the right. I can make it happen with Select statements, but that's not the right way. Just trying to figure out the "best" way without Select.
This is the code that works:
This does not (I get an Object Required error on the second line):
Locat = Sheets(2).Range("a1").Address
This also does not work -I get a Compile error Expected: List seperator or ) and it highlights the period beforee end
I know I am just doing one thing wrong, but can't find it. Thanks in advance.