ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically finding the last row in a SS (https://www.excelbanter.com/excel-programming/303457-re-automatically-finding-last-row-ss.html)

Ron de Bruin

Automatically finding the last row in a SS
 
I'm not very Visual Basic saavy. Is there a command you can use by mouse?
No


I am trying to run a macro to pull info

This will do what you want
http://www.rondebruin.nl/copy3.htm


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


"TPenner" wrote in message ...
I'm not very Visual Basic saavy. Is there a command you can use by mouse?

"TPenner" wrote:

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





All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com