Potential Bug in Find All application

M

MP

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
 
D

Dave Peterson

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.
 
Top