Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names in macros - DA
One of the things I don't like about macros is that, if you insert rows, it
will mess up macros programmed to go to specific locations. As my massive files evolve, I become paranoid, not to do anything that could move things around (and I'm not organized enough to keep a log of such cells). This handcuffs me. I understand that, if you give a cell(s) a range name, then you can use that instead and then the macro will adjust if the cell gets moved. Can someone write me the equivalent of the following code if I name the first cell "Joe" and the block of cells "Jane"? Application.Goto Reference:="R16C4" ActiveCell.FormulaR1C1 = "0" Selection.Copy Range("D16:D18").Select Range(Selection, Selection.End(xlToRight)).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Thanks! Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
version differences in excel 2007 - use of macros & range names | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Defined names in Macros | Excel Programming | |||
Range names in a Excell macros | Excel Programming |