Have you tried datafilterautofiltercustom <1

--
Don Guillett
SalesAid Software

"tskogstrom" wrote in message
ps.com...
Hi,

I have several areas but all cells also are one named range
"ALL_PERCENT_CL", if that helps. The cells have format percent and
should be 100% as standard, but user can change this to any
perecentage, like 30% instead. It could also be a formula "=2*20%" of
course. Or "0" or "". (If needed, I could set some conditional
formatting on the cells - they could even contain letters!.)

-- How can I fastest (9000 cells in total) find the cells that are not
100%?

I have tested some "non-loops" solutions like Find-next and GoTo, but
couldn't make it out.

Any knowledge in this to share?

Kind regards
tskogstrom