I figured out how to do this using R1C1 nomenclature. But now I need to
enter an equation with absolute and relative references using VBA. Here is
the equation:

=G12+(B13*D$5*E$8)/1000

How would I enter an equation like this?

"OkieViking" wrote:

I want to write a code that inserts an equation, using relative addresses
(i.e. the cell above minus the cell to the left of the active cell). How do
i do that