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

## Bookmarks