For Loop in Macro for generating continuous nos with a condition

I am new to Macros.

i am using a for loop for generating continuous numbers in A column and i would like to add a condition.

Condition:
If column B2 has a value then the For-loop should generate the next number in A3 and it goes on...if B3 has a value then it should generate the next series of no in A4

A B
No Name
1 sam
2


Kindly help me on this.

Another approach would be to copy and paste the following code into the worksheet module (not a regular module). This method will automatically add and increase the number in column A when you enter the name in column B.

Please Login or Register  to view this content.

@patel45 - Thx for your quick respone..bt your code is not working as i expected

@Mumps1 - I copy pasted your code and it works perfectly fine..Thanks a lot.
But in couple of scenario's the counting starts from '1' again.
Scenario:
if one of the cell in B column is blank and the next cell i fill in some value. It starts the counting from 1 again.

Try:

Please Login or Register  to view this content.

if i merge column A12 to A15, then again it starts the counting from 1 from A16.

Merged areas most often cause problems in Excel. You should avoid them whenever possible. I'm not really sure how I can help you. Perhaps someone else in the forum might have a solution.