shouldn't take that long to do it, just turn off the screenupdating.

--


Gary


"Rob" wrote in message
...
That was my original plan, until i realized i don't want to run it 333, or
once per cell. The code in the loop is searching for a specific value, i
want
the search to only take place between E1 and E333, and once it reaches
E333
stop searching.

"Jim May" wrote:

For i = 1 to 333
'your code here
next i


"Rob" wrote:

i want to write a loop that will run until it reaches cell E333,
starting at
E1.