get last column of say row 10 ?

[daveyc18]

indirect("r10:c"&counta(10:10), false)


this works but indirect is volatile ...is there another way ?

 

[jolivanes]

MsgBox Cells(2, Columns.Count).End(xlToLeft).Column
MsgBox Range("XFD8").End(xlToLeft).Column

 

[daveyc18]

MsgBox Cells(2, Columns.Count).End(xlToLeft).Column
MsgBox Range("XFD8").End(xlToLeft).Column

Ty but seeking a formula solution

 

[Alex Blakenburg]

You might want to update your profile so we can see what version of Excel you are using.
If you have MS 365 XLookup returns the Cell, so this might work for you.

=XLOOKUP(TRUE,10:10<>"",10:10,"",0,-1)

 

[daveyc18]

You might want to update your profile so we can see what version of Excel you are using.
If you have MS 365 XLookup returns the Cell, so this might work for you.

=XLOOKUP(TRUE,10:10<>"",10:10,"",0,-1)

tks

 

[Alex Blakenburg]

You're welcome.