how to end for/next loop?

[macnabong]

Need help to stop the procedure if the next row is blank:

here's the code:

Please Login or Register  to view this content.

thanks in advanced!

[:) Sixthsense :)]

Use this inside the for statement

Please Login or Register  to view this content.

Change this to your actual cell

Please Login or Register  to view this content.

[macnabong]

Please Login or Register  to view this content.

it says compile error

[:) Sixthsense :)]

Please Login or Register  to view this content.

[macnabong]

It worked! Thanks.

[macnabong]

I have another problem when i run the code, it converts to pdf with the filename base on the dropdown menu but the data is not the one for that name the data content is the content of the next row.

Thanks