Hi All,
New enough to this VBA, I am trying to copy the last row of data in column A and paste it to another workbook
I am currently using this bit of code
This code runs but I cant tell where it is referencing as it keeps returning blank, and the cell i want isn't blank. I have been messing with the Offset and xlUp and xlDown but to no avail.
Please Login or Register to view this content.
Hope somebody can help me
Simon
Take out the .Offset(1) and it should work
You could also use the .specialcells(xllastcell) as I have seen on here a few times but I am less familiar with that approach, may take trial and error.
Last edited by Hawkeye16; 07-08-2014 at 07:21 AM.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
I had tried that but It still returns a blank, I had originally put the offset in as i thought it might be returning the blank cell just below the last cell with a value. but still no joy
That should work. To help dubug you can put a statement like this is right after the copy statement to make sure it is working correctly or see what the issue is.
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Thanks Hawkeye, That bit of debugging made it very clear what the issue was, there are formulas in column A so it was returning the last cell with a formula in it, which was returning blank.
I will simply use column C and an offset.
Thanks for your help. Rep Added
No problem, thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks