I have 5 sheets that I want to have a macro that copy/pastes rows into a new sheet, Sheet6.
Does anyone know the code for finding the first row in sheet6 that is not used/has no value in column A?
Thanks so much.
I have 5 sheets that I want to have a macro that copy/pastes rows into a new sheet, Sheet6.
Does anyone know the code for finding the first row in sheet6 that is not used/has no value in column A?
Thanks so much.
Last edited by TShelt; 12-15-2011 at 01:24 PM.
try this:
Regards,![]()
Please Login or Register to view this content.
Khaled Elshaer
Remember To:
1. Thank those who have helped you by clicking the Star below the post.
2. Mark your post [SOLVED] if it has been answered satisfactorily.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks