ExcelBanter - Entering Sum formula into a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Entering Sum formula into a cell (https://www.excelbanter.com/excel-programming/278244-re-entering-sum-formula-into-cell.html)

Don Guillett[_4_]

Entering Sum formula into a cell

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

All times are GMT +1. The time now is 09:58 PM.