VBE code to move selected data

[bcarney1]

Hello-
Could you tell me the VBE code (below) needed to move (paste) a
"selected range of cells" to a cell just above the activecell - i.e.,
same column, just one row up? NOTE: Don't want absolute reference like
"Range("G15").Select" because I will need to repeat this macro on
different rows of data. This must be a simple thing, except for a
novice like me. Thanks in advance. _Bill

Sub Move()
' Move Macro
' Macro recorded 3/11/2004 by Bcarney1
'
' Keyboard Shortcut: Ctrl+s
Range(ActiveCell, ActiveCell.Offset(3, 7)).Cut

' ActiveSheet.Paste
End Sub

 

[Frank Kabel]

Hi
try replacing
' ActiveSheet.Paste
with
ActiveSheet.Paste Destination:= Activecell.offset(-1,0)