My macos won't run on the next row (it only works on the first row)

Hi all, I am a truly newbie in vba macro, any help is very much appreciated.

In my column A, I have the folloling 9 rows, where row 4 and row 6 are left blank for testing.

Nominal Date: 1
Nominal Date: 2
Nominal Date: 3

Text

Nominal Date: 4
Nominal Date: 5
Last

What I wish to do is to seperate the Nominal Date into 2 columns, e.g Nominal Date in column A and the date 1 in column B.
The blanks cell are for testing whether it will skip and go to the next row.
The "Tex"t and "Last" row are used for testing as well.

I came out with the code:

Please Login or Register  to view this content.

The problem is, the macro only works on the first row, it will not go down to the second row onwards. I use debugging but it didn't show any error message and the selected cell just stopped at the first row.

I have no idea what happened. Any help is very much appreciated.

Thank you.

PS: I have a long list but the length varies across the months. If possible, I would like to use do until loop instead of For.. next. Is it possible to stop the macro base on the condition of the next row? e.g. if i+1=9 is the text Last, is it possible to stop the macro (or loop the macro) until the row i=8? Thank you very much

Please Login or Register  to view this content.

Try this..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi, hcyeap,

or simplify your code:

Please Login or Register  to view this content.

Ciao,
Holger