View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rusty[_6_] Rusty[_6_] is offline
external usenet poster
 
Posts: 2
Default 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