how to select to second next cell in a row after the last one used

[cazdealer]

Hi, I have data in Row 1 for A1 to ?1 ...
lets say last used cell in row 1 is AT1... how can I setup sometime that will select the second next cell (AV1 is this exemple)

thanks

 

[tweedle]

Is this a Macro/VBA question?

 

[cazdealer]

sorry, yes, I need it for a VBA code line

 

[jim may]

Assign a Short-Cut-Key to this macro (pasted into a Stabdatd module)

Sub Foo()
LC = Range("XFD1").End(xlToLeft).Column + 2
Cells(1, LC).Select
End Sub

 

[cazdealer]

Jim,
it doesnt work

 

[tweedle]

What about it doesn't work? Seems fine on mine...

 

[cazdealer]

I used this below finally
thanks for the help

Range("XFD1").End(xlToLeft).Offset(0, 2).Select