Running macro from currently selected cell?

G

GD

Can a macro be programmed to run from the currently selected cell, rather
than a specific cell location? In other words, can the starting point of a
macro change, based on the cell that is currently selected?

I am required to copy & paste lines of data from wIntegrate (non-MS app)
into a spreadsheet, and then format and calculate them to insure accuracy.
Each copy & paste job is entered below the last one, but all formats and
formulas are pretty much the same. I'd like to record a macro that affects
from the uppermost row of the current copy & paste job downward, but nothing
above it.

Any help?

Thanks for the brainwaves!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a macro from currently selected cell? 1
Need macro to move to first blank cell in column 6
Running a macro in a selected cell... 2
problems getting this macro to work 23
How to get from inside a VB macro the currently marked cell? 2
Finding row, then copy paste (macro) 5
Perform oiperations relative to initial selected cell 1
Excel macro 1

Top