View Single Post
  #1   Report Post  
Gord Dibben
 
Posts: n/a
Default

Luka

Couple of examples...

Sub ActivateNextBlankDown()
ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
End Sub


Sub Interval_Entry()
i = 1
todo = InputBox("Enter a number")
Do While todo * i < 910
Cells(todo * i, 1) = 88
i = i + 1
Loop
End Sub


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 11:59:01 -0800, "Luka"
wrote:

I need "Do While" Function in Excel,but is not in. How I can replace it?