ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting the first blank cell in a column (https://www.excelbanter.com/excel-programming/387586-selecting-first-blank-cell-column.html)

BZeyger

Selecting the first blank cell in a column
 
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

Don Guillett

Selecting the first blank cell in a column
 
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

--
Don Guillett
SalesAid Software

"BZeyger" wrote in message
...
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




All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com