Excel macro, editing recorded cell.. not current
 

So I recorded a Macro... and I want it to be able to edit values next to the
current cell, not the ones i recorded the macro on.

here is the macro file..


Range("K3").Select
Selection.Insert Shift:=xlDown
Range("K3:L3").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("I4").Select

Excel macro, editing recorded cell.. not current
 

ActiveCell.Offset(0,1).Insert Shift:=xlDown
With ActiveCell.Resize(1,2).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With


--
Regards,
Tom Ogilvy


"TroyT" wrote in message
...
So I recorded a Macro... and I want it to be able to edit values next to
the
current cell, not the ones i recorded the macro on.

here is the macro file..


Range("K3").Select
Selection.Insert Shift:=xlDown
Range("K3:L3").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("I4").Select