How to create a formula in VBA to assign to a cell
Hi,
I'm trying to sum up some cells in a simple formula to assign to a
different cell. For example "=sum(E5:E33)"
However, do I create the above line of code without hard-coding the range?
I do not want to used named ranges as I have thousand of rows to sum up.
Your help is appreciated.
Rusty
|