L
Luka
I need "Do While" Function in Excel,but is not in. How I can replace it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
nobody understand what you mean? Could you post some more information of what
it is you want to do
Regards,
Peo Sjoblom
B
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)
--
HTH
RP
(remove nothere from the email address if mailing direct)
G
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
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