View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Automatically finding the last row in a SS

Hi TPenner

Look here for some examples
http://www.rondebruin.nl/copy1.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TPenner" wrote in message ...
I am trying to run a macro to pull info. off different spreadsheets and put it into the last row (accumulating info. daily) of a

spreadsheet, but the macro is giving the row absolute cell reference, instead of relative. Example: It is putting the new info. in
row 742 every day instead of today 742, tomorrow 743, etc.

Thanks for any help!!!

Tim