Excel Absolute Cell Reference?

I want to write a Absolute Cell Reference but do not know how to write this out. I have a Toll Bridge Survey what is written in a box/cell in Colums e3, e4 and e5 I have Car Price, Lorry Price and Motorbike Price. In section A to C I have Car's, Lorries and Motorbike this is the number of vehicles passing through . I need to write in the formula bar but do not know how to do this. Thank you

Excel Absolute Cell Reference?
For absolute cell reference, put a $ before the row and/or column.





So $e$3 would always refer to cell e3.


$e3 would always refer to column e, but the row could change.
Reply:absolute Cell refrence is when you put the dollar $ sign in between the Row and/or column.


If you want the row to change but not the column then this is how to write it


A$3


however if you want the column to change but not the row:


$A3


and if you want the row to stay and the column then it would look like this:


$A$3
Reply:Hi,


why don't you think of doing it all in VBA, it's easy and will be able to do so much more, to ref a cell in VBA you just put "Cells(row, column). value" it's that easy. hope this makes you think.