Hi all,

Using Excel 2007

Code below I think it should select blank cells down Column E
But the debug.print returns $E$1:$J$1
What am I doing wrong?
lngRowsTmp = 10526 which is correct

thx
w

With wsTmp
   Set rngColE = Range(.Cells(1, 5), .Cells(lngRowsTmp, 5).SpecialCells(xlCellTypeBlanks))
End with
   Debug.Print rngColE.Address