select first non blank cell
H,
If your columnd is filled with constants (entered values)
Range("A:A").SpecialCells(xlCellTypeConstants)(1). Select
If it has formulas
Range("A:A").SpecialCells(xlCellTypeFormulas)(1).S elect
HTH,
Bernie
MS Excel MVP
"JH" wrote in message
...
Hello everybody,
easy task (but not for me)
how to select first non blank cell in a column (eg. A)
starting row 1
thanks very much in advance
H
|