View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Loomah Loomah is offline
external usenet poster
 
Posts: 18
Default 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/