parscon
04-08-2013, 05:26 AM
I have a list in column A that there is a bank row between rows. Now I need add Auto increment number on blank rows and start from 4 till to up.
That mean:
A1: Blank
A2: DATA
A3: DATA
A4: Blank
A5: DATA
A6: DATA
A7: DATA
A8: Blank
After run VBA code will be:
A1: 4
A2: DATA
A3: DATA
A4: 5
A5: DATA
A6: DATA
A7: DATA
A8: 6
Also I added a Sample file enclosed this post.
Thank you very much
That mean:
A1: Blank
A2: DATA
A3: DATA
A4: Blank
A5: DATA
A6: DATA
A7: DATA
A8: Blank
After run VBA code will be:
A1: 4
A2: DATA
A3: DATA
A4: 5
A5: DATA
A6: DATA
A7: DATA
A8: 6
Also I added a Sample file enclosed this post.
Thank you very much