Counting cell formats

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

I'm going through the process of cleaning someone's ridiculous workbook of
it's cell formats - I just want to know if there is a line of code I can
stick in the Immediate Window that will tell me how many cell formats I have?

Thanks in advance
Daniel
 
ctrl + f | options | format | choose the formats | ok | find all

u can see the count of cells which matches the format u have choosen
in the find format.
 
Back
Top