If I record a Macro that performs a number of functions on a particular set
of data, can I then run the Macro on a different set of data without the
tesium of going into the VB editor and changing it manually?? I have tried
preselecting the new data set and running the macro, but it reverts back to
the original set in the VB code.

Any suggestions appreciated.