Hi all,
I have decided to post here to see if there is a solution to my Macro problem. I am faily new to Excel. I am supposed to be an Airframe and Powerplant Mecahnic but due to a job loss I have found myself using Excel at my new employment. I use a lot of macros that I record and edit to speed things up. One such puts column sum in the cell I select.
Here is the Macro:

Sub Sum()
'
' Sum Macro
'

'

ActiveCell.Formula = "=SUM(V3:R[-2]C)"

End Sub


Here's how it works:
I select the cell I want the sum in. Run the macro. It selects the cell 2 rows above my selected cell (R[-2]C) and enteres that in the formula. It creates the formula for me, =SUM('V3':V122) (the second number varies depending on the cell iselect). The problem is that since I put V3 in the macro as the first cell in the formula it adds the ' around it and I have to manually remove it.
Thanks, Joe