I am trying to make this code auto save data to the next row but it wont work any help appreciated.
Please Login or Register to view this content.
I am trying to make this code auto save data to the next row but it wont work any help appreciated.
Please Login or Register to view this content.
Last edited by Justin25150; 05-31-2012 at 11:10 PM.
Does your data extend to more than 65536 rows? If so, its better to use ......Cells(Rows.Count,1).End(xlup) .....
Is column A empty for the last otherwise filled row on your sheet? If so, you will get overwriting as described.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks