Macro that selects the cell next to clicked button [Closed]

Report
-
Hello,
I need to run a macro on the cell directly to the right of the button I clicked to run it

I will be running that macro on around 100 buttons down the spreadsheet so do not want to have to create a new macro for each one.

While the macro is running it also copies values from a specific cell, that cell does not change regardless of which of these buttons is pushed, so how do I run absolute and relative in the same macro.

Can someone help because i'm not a VBA boffin and I'm doing my head in.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!