Find all cells NOT containing "100%" -no loop solution needed
 

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

Find all cells NOT containing "100%" -no loop solution needed
 

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

Find all cells NOT containing "100%" -no loop solution needed
 

Sorry, not usable.

Need to change the cells back to 100%. I can't change all in the range,
since I will in next step use the only part of non 100% cells - that
are hidden. The visible cells should be intact.

I didn't cofuse you with this because this I already have routines for.

thanks for trying!

Regards,
tskogstrom


Don Guillett skrev:

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