Select cell next to last column VBA

[doriannjeshi]

Hi ,
Just as the title
I need to select the next cell of the first row next to the last column, with vba

 

[MARK858]

Is this not basically what you asked in the thread in the link?

Select to the last column -1, VBA

Hi, I need to select a range ctrl+shift right to the end column -1 column with VBA

www.mrexcel.com

 

[doriannjeshi]

The next cell after the last column , is it the same ?
last column +1

 

[MARK858]

If it is the next cell after just change the -1 to 1

 

[doriannjeshi]

oh well,
Nor that is allowing me to select the cell I want
my data ends in column Ak1 and I need to select Al1 (where I will place a formula)

 

[MARK858]

my data ends in column Ak1

Are the cells after it truly blank or formulas returning ""

If they are truly blank and on row 1 one way is just

Cells(1, Columns.count).End(xlToLeft).Offset(, 1).Select

If it is formulas returning "" then it is

Rows(1).Find("*", , xlValues, , xlByColumns, xlPrevious).Offset(, 1).Select

 

[doriannjeshi]

Are the cells after it truly blank or formulas returning ""

If they are truly blank and on row 1 one way is just

Cells(1, Columns.count).End(xlToLeft).Offset(, 1).Select

If it is formulas returning "" then it is

Rows(1).Find("*", , xlValues, , xlByColumns, xlPrevious).Offset(, 1).Select

Yes, this is it
Thank you Mark