Quote:
Originally Posted by ewso
When I record macros, the macro always remembers the cell range I have selected at the time I record the macro. But when I want to run the macro, I need the macro to run on the selected range I'm using at the time, not on the same range I had selected when I recorded the macro. What can be done?
thanks
|
If you look to record another macro, but this time rather than recording you selecting the cells, select the cells first befiore you record, then when have finished. You should be able to select any other range to do what you need it to do.
But it also depends on what you are wanting the recording to do....