Find all formatted cells

T

Todd

Is there a way to do something like this code to find all formatted
cells?

Set rngData = rngRange.SpecialCells(xlFormats)

tia
 
T

Tom Ogilvy

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

so no, there is no specialcells for this
 
Top