Fixed and Relative Macro References
Thanks Jim, That one works.
I thought the act of copying would change the selection.
kudos for deciphering my imprecise question.
"Jim Thomlinson" wrote:
You can do it in 1 macro. Actually you can do it with one line of code...
Range("A1:A10").Copy Destination:= Activecell.offset(0,2)
Change the A1:A10 to suit.
--
HTH...
Jim Thomlinson
"uturnabout" wrote:
I am trying to learn about what macros can and can't do.
Essentially, I want to copy data from a fixed location and paste it in a
relative location. It seems like this should be possible, but no matter what
I try, it fails.
Most recently, I have tried to use two separate macros.
Macro 1 selects and copies the fixed data.
Selection.Copy
Macro 2 should paste two spaces to the right of where the cursor is.
ActiveCell.Offset(0, 2).Range("A1").Select
ActiveSheet.Paste
I have recorded these macros, but when I try to run Macro 2, I get an error
(either 1004 or 438 if that is relevant)
Is what I am trying to do possible?
|