Counting cell formats
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 |
Counting cell formats
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. On Oct 2, 7:25*pm, Daniel Bonallack wrote: 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 |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com