sytax to select next row

what is the sytax to select the next row.
here is what i have:

Please Login or Register  to view this content.

Any help will be very appreciated. thanks.

artromanov

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

Try replacing your macro with this single line command

Please Login or Register  to view this content.

What the above code does is :-
Cells command uses Cells(Row number, Column number or letter)

Please Login or Register  to view this content.

From b7 look down column B for the last entry brfore a blank cell. Get the row number & add 1 to it.
The row number is then used in the Cells command