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
Bookmarks