VBA - Making Cell a Constant

[bforster1]

I have a program that allows the user to insert additional revenue an
expense lines. However, whenever a new row is inserted my formulas ar
thrown off. How do I make a cell constant.

Example

C11/C14 ...... when ever I insert a new row C14 becomes C15 and I nee
the formula to change accordingly.

Any ideas..thanks

 

[Dave Peterson]

if you're trying to make your formula always point to cell C14--no matter how
many rows/columns you insert/delete, you can do something like this:

=C11/INDIRECT("c14")

You could do the same with C11 if you wanted.