Paste Values from one work sheet to another, but in a row that blank between (rows 5 -105)

[nenadmail]

I have the first part of my VBA code (see below)... but I don't know how to program the rest of it. Pleas help!

I need the copied information to be pasted.special as VALUES ONLY into another worksheet called "Basket"
However the range it pastes it to needs to be somewhere between rows (5 through 105) in columns "AA:AF".
The criteria is this: IF AA5 has values in it, then paste in the next row, if the next row has values, then the following one... basically it keeps searching for the next available blank row to paste this data in (search up to row 105, if they're all filled, then it brings up an error msg)... How do I program that in this code?

Please Login or Register  to view this content.

Thank you!

[rylo]

Hi

try

Please Login or Register  to view this content.

rylo

[nenadmail]

Great it works thanks!