View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TroyT TroyT is offline
external usenet poster
 
Posts: 19
Default 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