How i can replace function

[Guest]

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

 

[Guest]

The most likely reason you haven't received an answer is probably because
nobody understand what you mean? Could you post some more information of what
it is you want to do

Regards,

Peo Sjoblom

 

[Bob Phillips]

Do you mean in a worksheet function? I don't think so, you need a UDF.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

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