Right then guys. I've got a workbook and it's got a fuck-ton of named ranges in it (with no consistent style applied to how they're named). It's a mess. I'm doing a validation on it and want to highlight that having 1,000's of named ranges make the workbook really hard to validate and test.

So how can I count the number of named ranges in a workbook? I'm guessing there's a way in VBA but need a quick solution if anyone has one. Google not really helping.

Cheers xxx