Hi,

It's always a good idea to post code/formula you have tried but the snippet
of code you supplied will go into a very long and probably endless loop if
run so avoid doing that.

Perhaps you could explain more clearly what you are trying to do.

Mike

"filip" wrote:

I am counting number of cells i have to iterate with next piece of code:
Dim rows

Do While Not (IsEmpty(ActiveCell))
rows = ActiveCell.Row
ActiveCell.Offset(1, 0).Select
Loop

is it possible to do the same without selecting?