Look in the help index for OFFSET
activecell.offset(1)=1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GD" wrote in message
...
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!
--
GD