Mary90
New Member
- Joined
- Sep 8, 2015
- Messages
- 22
Good day guys.
I'm looking for a way to list all used number formats in my workbook, along with a count of how many cells use each number format.
I've tried running a loop through each cell in each worksheet, but I can't get it to work.
Google has not provided any usable results
Does anyone have some ideas on how to do this?
Thanks!
Mary
I'm looking for a way to list all used number formats in my workbook, along with a count of how many cells use each number format.
I've tried running a loop through each cell in each worksheet, but I can't get it to work.
Google has not provided any usable results

Thanks!
Mary