Macro Help

  • Thread starter Thread starter steveski
  • Start date Start date
S

steveski

I recorded a macro. I want the macro to start its operation from th
cell that I select, and do everything with the selected cell as th
reference point. However, the macro wants to go back to the exact cel
that I had selected when I recorded it. How can I make the macr
dynamically reference the cell I select rather than the cell which wa
selected when the macro was recorded?

Thanks
 
Hi
you have to change the macro code :-) It would be helpful if you post
your code so that we can give you some ideas what to change. e.g.
replace a fixed reference as starting point with ActiveCell, etc.
 
Tools|macro|record new macro.

When the "stop recording" toolbar pops up, let your cursor linger of the second
icon on that toolbar.

You'll see it has a tooltip of "relative reference"

Click on it and record your macro again.
 
Back
Top