I was using a find all loop in VBA (self programmed) which was causing Excel
to hang. I didn't know what caused this so i investigated using find next in
excel. This didn't show me anything so i then used the Find All function and
got 65472 hits 65466 of them in one cell. The Cell has the contents "Drug
Retailers" and i was searching for "ug".

I don't know if the cell has corrupted in some way or if the find all
function isn't stable. Either way i'd like some guidance.

Thanks

The only problem I've ever had with Find's going into loops is when I've used
merged cells.

The only two solutions I had were to not use merged cells--or not to use my Find
routine.

MP wrote:

I was using a find all loop in VBA (self programmed) which was causing Excel
to hang. I didn't know what caused this so i investigated using find next in
excel. This didn't show me anything so i then used the Find All function and
got 65472 hits 65466 of them in one cell. The Cell has the contents "Drug
Retailers" and i was searching for "ug".

I don't know if the cell has corrupted in some way or if the find all
function isn't stable. Either way i'd like some guidance.

Thanks

--

Dave Peterson