First row not used code

[TShelt]

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.

[Kelshaer]

try this:

dim r as long
r = worksheets("Sheet6").usedrange.rows.count + 1

Regards,
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.