I am using a worksheet that is thirteen column wide.
I post Payment made in column "A", ending balance is in column “J”.
I need to know balance in column "J" of same row the last posting was made.
How can I get this balance?
This macro I wrote will do it, but there must be a better way.
I can use this code to move down:
ActiveWindow.SmallScroll Down:=7

But how can I move right or left a number of cells?
This will move all the way to right:
Selection.End(xlToRight).Select

Macro that I use now:
Sub NBal()
'
' NBal Macro
'
' Keyboard Shortcut: Ctrl+Shift+T
'
Range("A20").Select
Selection.End(xlDown).Select
Selection.Copy
Range("L12").Select
ActiveSheet.Paste Link:=True
Range("A20").Select
Selection.End(xlDown).Select

Application.CutCopyMode = False
Selection.Copy
Range("L14").Select
ActiveSheet.Paste Link:=True
Application.CutCopyMode = False
Range("A20").Select
End Sub

Thanks in advance