loop

[FROGGER24]

how do you create a do loop until column b is empty

thanks in advance

 

[Legacy 63186]

Try the following code.

Sub DoWhileDeom()
Do While Not IsEmpty(ActiveCell)
'Insert what you want to do with the value here
ActiveCell.Offset(1,0).select
Loop
End Sub

 

[Scott Huish]

Empty meaning the last filled cell in Column B? What are you trying to do exactly?