Hi,

The code is much faster than its other predecessors as you have used the Arrays. Many thanks for this.

I believe there is no other way than to loop through each cell on each sheet to identify the used cell styles, as for models with large used ranges and many sheets. This will take a little bit longer.

Just one quick comment, we should have error trapping in the same, as I have encountered error 'Method 'UsedRange' of object '_Worksheet' failed'.

But again many thanks for this and in such a quick time...

Super and keep rocking guys

Cheers
Sidd