UsedRange & Formatting of Cells
Yes, cell shading constitutes part of the UsedRange
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
"JStone0218" wrote in message
...
When I use the code below, the shading of the cells in column A impact the
UsedRange. Is this normal?
For Each cell In ActiveSheet.UsedRange.Columns(1).Rows
|