try
=SUM(startrow:endrow)

"Parker" wrote in message
...
I am having trouble entering a sum formula from a macro
into a cell. I have defined variables called 'StartRow'
and 'EndRow' and I want to enter a sum formula for column
N from 'StartRow' to 'EndRow' into the active cell. I
don't know how to incopropate the variables into the sum
formula.

Any help would be greatly appreciated.

Thanks in advance!

Parker