Start a Macro with First Action at Variable (Changing) Cells

[Bobaree6]

Is it possible to create a macro where the first action takes place in the activated cell and were that activated cell may change each time the macro is run? For example, I would move the cursor to A1 to activate it. Running the macro would do a copy from A1 followed by a paste to another cell.

On another occasion, I would activate A2. The macro would do a copy from A2, followed by a paste to another cell.

In each case, additional actions would follow.

 

[EFANYoutube]

selection.copy

 

[Bobaree6]

selection.copy

Could you be more specific how I would incorporate this in a macro? I am somewhat of a beginner.

 

[Bobaree6]

EFANYoutube: Thank you so much for your answer. I think I see how to incorporate "selection.copy" into the macro, but now I need it to move 6 columns to the right (a relative move in each case) to copy and paste something else. Can you help me with that too?

 

[EFANYoutube]

Hi Bobaree

The best way of doing this is without select. is there a reason you need the cells to be "activated"?

As long as you stay on the same sheet you can use the below

Sub cool()
Range("A1").Copy Range("A7")
'Copy from  ----  Copy to
End Sub