Activate first blank cell
 

Hi,

I need to activate the first empty cell in a column.
Can someone help me?


---
Message posted from http://www.ExcelForum.com/

Activate first blank cell
 

you could use
range("a1").end(xldown).offset(1,0).activate
for cells in column A
You could also use
range("a65536").end(xlup).offset(1,0).activate
depends on your data
;-)

serge wrote in message
...
Hi,

I need to activate the first empty cell in a column.
Can someone help me?


---
Message posted from http://www.ExcelForum.com/

Activate first blank cell
 

-----Original Message-----
Hi,

I need to activate the first empty cell in a column.
Can someone help me?


---
Message posted from http://www.ExcelForum.com/

.


Put cursor on any data in cell and then SHIFT+END,
SHIFT+Arrow down.