Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recorded macro has hard cell contents. | Excel Discussion (Misc queries) | |||
Editing recorded macro code. Referencing workbook name in functio | Excel Programming | |||
how is the syntax to replace a date, recorded within a macro with a cell value ? | Excel Programming | |||
how is the syntax to replace a date, recorded within a macro with a cell value ? | Excel Programming | |||
how to run recorded macro without showing processing excel sheets | Excel Programming |