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
Bookmarks