I need to be able to list or cycle trough all custom number formats defined for a workbook (end goal: to delete them all).
Can someone tell me how to do this without cycling through every populated cell on every worksheet
In order to use <workbook>.DeleteNumberFormat you already need to know the number format - this I need to list them all.
I have see other forum postings & pages which seem to suggest they are looking for the same thing but all those i have so far found refer the questioner to a link with is no longer valid.
Any help would be much appreciated.