How to specify a range for a macro to run

[bburrus]

I have a macro that I created with the help of others and I need to start the macro at different cells which vary by tabs within the workbook.

How do I specify a range to where I can click any cell in any tab and have the macro function how it's designed to do?

Thanks guys and gals!

[Tinbendr]

Your question is too vague. To the end of the column? To the end of the row? If it's only the active cell, then use ActiveCell.

[bburrus]

I have a worksheet with multiple tabs in it. There are month timelines that end and start at different cells. This macro below extends the months to a user specified amount but it only does this from whatever data is on cell A4. I need to be able to click on any cell on any worksheet and be able to run the timeline extension.

Please Login or Register  to view this content.

[bburrus]

Where would I put the ActiveCell in my formula. I'd obviously have to take something out

[Tinbendr]

Please Login or Register  to view this content.