Activate first blank cell

  • Thread starter Thread starter serge
  • Start date Start date
S

serge

Hi,

I need to activate the first empty cell in a column.
Can someone help me?
 
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
;-)
 
-----Original Message-----
Hi,

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

Put cursor on any data in cell and then SHIFT+END,
SHIFT+Arrow down.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Conditional listbox cell populating 4
Search for empty cells and move cells next to 10
VBA code to find first blank cell in a column and activate it 4
sub tot column to next blank cell when blank cell exists in both c 2
Marking found records in Workbook A from Target List in Workbook B 1
Need Macro... 8

Back
Top