View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JStone0218 JStone0218 is offline
external usenet poster
 
Posts: 12
Default UsedRange & Formatting of Cells

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