View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Rosenberg[_2_] Robert Rosenberg[_2_] is offline
external usenet poster
 
Posts: 24
Default 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