Forum Discussion
Nested Loop
Hi, I am trying to do a nested Loop with a Do Until and a While. See attached. when starting the loop it ignores the outside loop but do the inside loop perfectly. Outside loop to be done fo...
Thanks for your help. It works perfectly. I just had to remove the "end if" statement. It presented a compile error " End If without block If "
In your answer, how did you tell the system to dublicate the name eg 7 times ? I don't get that part of the makro.
Regards
By resizing the range: destCell.Resize(rowsize, colsize) where rowsize equals the value that is in Column H. Excel can read/write a block of cells at once - it's Range("O3:O9").Value = "Name" instead of doing one cell at a time.