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

Bobaree6

New Member
Joined
Dec 23, 2020
Messages
18
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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?
 
Upvote 0
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

VBA Code:
Sub cool()
Range("A1").Copy Range("A7")
'Copy from  ----  Copy to
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top