All cells are formatted - some just have the default format.

so no, there is no specialcells for this

--
Regards,
Tom Ogilvy

wrote in message
...
Is there a way to do something like this code to find all formatted
cells?

Set rngData = rngRange.SpecialCells(xlFormats)

tia