| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Relative Reference in a Formula
I am having trouble using a formula. Here is the formula I am trying to make
work: ActiveCell.FormulaR1C1 = "=ROUND(RC[-1]*Cell A1". The "Cell A1" is the cell that I want to reference. This formula will be used in mulitiple rows but it will always look for the value of cell A1. The problem is that it will not let me mix both relative and absolute references in the formula. I guess that I could also assign a variable with the value of cell A1 and use that in the formula. But I don't know how to do that either. Does anyone know how to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing relative to a formula reference | Excel Worksheet Functions | |||
| Relative Range Reference in a sumifs formula | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| Mixing Absolute and Relative Reference in a Formula | Excel Programming | |||
Threaded Mode
