I would like to have my macro copy paste range value from column b to J but
cannot seem to modify from a fixed postion to active cell. Ideally I want to
be able to move cell to any row in column b and run macro. Any help is
appreciated.

Sub Macro2()
Range("B11:J11").Select
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
Range("B11:M11").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.Goto Reference:="HomeBase"
End Sub