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

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

"Luka" wrote:

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

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)


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

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?