Hello, I do not know VBA can someone please help to edit below code so that the macro runs in a different cell (cell of users choice) each time. Currently it repeats itself in the same cell. Thanks in advance.
Sub UnitPrice()
'
' UnitPrice Macro
'
' Keyboard Shortcut: Ctrl+u
'
ActiveWindow.SmallScroll Down:=-9
Range("B106:M111").Select
Selection.Copy
ActiveWindow.ScrollRow = 103
ActiveWindow.ScrollRow = 102
ActiveWindow.ScrollRow = 100
ActiveWindow.ScrollRow = 99
ActiveWindow.ScrollRow = 98
ActiveWindow.ScrollRow = 96
ActiveWindow.ScrollRow = 27
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 22
ActiveWindow.ScrollRow = 9
Range("B10").Select
ActiveSheet.Paste
End Sub
Sub UnitPrice()
'
' UnitPrice Macro
'
' Keyboard Shortcut: Ctrl+u
'
ActiveWindow.SmallScroll Down:=-9
Range("B106:M111").Select
Selection.Copy
ActiveWindow.ScrollRow = 103
ActiveWindow.ScrollRow = 102
ActiveWindow.ScrollRow = 100
ActiveWindow.ScrollRow = 99
ActiveWindow.ScrollRow = 98
ActiveWindow.ScrollRow = 96
ActiveWindow.ScrollRow = 27
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 22
ActiveWindow.ScrollRow = 9
Range("B10").Select
ActiveSheet.Paste
End Sub