View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default defining a range

Hi All,

I defined a range containing empty cells in column C:
Dim emptycells As Range
Set emptycells = Columns("C:C").SpecialCells(xlCellTypeBlanks)

How can I define another range that contains all rows in which these empty
cells occur?

Thanks,
Stefi