View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default Running macro from currently selected cell?

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