Running a macro from currently selected cell?
 

How do I record a macro to run from the cell that is currently selected,
rather than a specific cell number?

I copy & paste data from wIntegrate (non-MS app) to a spreadsheet, and then
perform much the same functions every time to make sure the data is correct.
Every copy & paste job goes below the last, so I need for a macro to read
the cell currently selected and run the macro from that point.

Thanks for the brainwaves!
--
GD

Running a macro from currently selected cell?
 

A recorded macro is going to be full of "selects". These will be hard coded
constants. What you need to do is to remove those selects and make the
refernces relative. That is easier said than done if you don't understand the
XL object model. To that end record what you want done and post it. We can
help you make the necessary changes.
--
HTH...

Jim Thomlinson


"GD" wrote:

How do I record a macro to run from the cell that is currently selected,
rather than a specific cell number?

I copy & paste data from wIntegrate (non-MS app) to a spreadsheet, and then
perform much the same functions every time to make sure the data is correct.
Every copy & paste job goes below the last, so I need for a macro to read
the cell currently selected and run the macro from that point.

Thanks for the brainwaves!
--
GD