Finding the last row of data.

[whatsmyname]

Hello all,

I need to find the last row of data in my worksheet and then cut the last row of the worksheet(65565) and then paste it in the first blank row after the last row of data.

I'm assuming that this would have to be a VBA code, but I am not skilled enough to do this.

Any help would be greatly appreciated.

Thank you and have a great day.

[whatsmyname]

You know, now that I think about it, the last row of data would be the row that I want to cut(655565).

I need to somehow ignore this row and find the other last row of data.

[stnkynts]

This will take the last row in sheet 1 and cut/paste it to the next available row on sheet 2. It is done on the assumption that your data is in column A. Let me know if it works.

Please Login or Register  to view this content.