I am recording a Macro and when I get to a specific location in the spreadsheet I want to move right one space regardless of what column I am in. How do I tell it to do this in visual basic.

Right now in my macro it says the following:

Application.Goto Reference:="R1C152"
Selection.End(xlToLeft).Select
Range("K1").Select
End Sub

It will go to K1 every time. I want it to move right one cell after it does the following command:

Selection.End(xlToLeft).Select

All help is appreciated.

Thanks