Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select first non blank cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I select the first blank cell | Excel Worksheet Functions | |||
How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
macro select next blank cell in a row | Excel Programming | |||
I want to select the first blank cell in column A | Excel Worksheet Functions | |||
Select blank cell | Excel Programming |