Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a macro to start in the right spot!
I have a few macros that I use to input predetermined numbers in cells.
ie: Sub testmacro() Range("A3").Select ActiveCell.FormulaR1C1 = "25" Range("A4").Select ActiveCell.FormulaR1C1 = "10" Range("A5").Select ActiveCell.FormulaR1C1 = "2" Range("A6").Select ActiveCell.FormulaR1C1 = "4" Range("A7").Select End Sub The problem is that if a row is inserted above A3 then I want the macr to start at A4. In other words I want it to start in the same relativ cell. Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a macro to start in the right spot!
You could give a name to each of your target cell, and that name woul
remain with the cell wherever it goes as a result of insertions, etc. You can name your ranges in Excel by doing InsertNameDefine, or yo can simply select your target cell, type a range name in the Name bo near the top left of the worksheet screen and (required) press Enter. billy -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a macro to start in the right spot!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X marks the spot | Excel Discussion (Misc queries) | |||
Hosur an IT hot spot? | Excel Worksheet Functions | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
I want a name in one spot and it's code in another | Excel Discussion (Misc queries) | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |