Selecting the first blank cell in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tring to program in excel and I am having a hard time selecting the
first blank cell in a column. There is data throughout and i want the first
blank cell to be slected. I have tried using the Ctrl down... Can someone
help me out... I know its simple but I am just getting started in VBA.

Thanks
 
In the absense of more detail, this should do what you want. However,
selections are usually not desireable or necessary.

Sub gotonextblank()
ActiveCell.End(xlDown).Offset(1).Select
End Sub
 
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
Multiple SUM's in a column 15
Blank cells corrupt? 3
Excel Concatenate with line breaks but ignore blank cells 3
Concat a three column range into one cell Then Next... 2
first non blank cell 3
Issue with blanks and spaces 56
Macro to Copy and Paste Cell Contents 2

Back
Top