| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use absolute references in macros?
How do I setup absolute cell references in macros with either R1C1 format or
A1 format. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use absolute references in macros?
Using A1 notation for cell B1 it would be...
Range("B1").Formula = "=$A$1" HTH. "Michael" wrote: How do I setup absolute cell references in macros with either R1C1 format or A1 format. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use absolute references in macros?
Thank you.
"DaveO" wrote: Using A1 notation for cell B1 it would be... Range("B1").Formula = "=$A$1" HTH. "Michael" wrote: How do I setup absolute cell references in macros with either R1C1 format or A1 format. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Absolute References | Excel Worksheet Functions | |||
| Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
| Absolute references | Excel Programming | |||
Hybrid Mode
