Doing a Simple Sum in VBA
Posted by John L. on May 12, 2001 10:06 AM
Can anyone tell how to do a simple sum in VBA.
On a spreadsheet I can manually place the cursor at the
bottom of a column of numbers and double-click on the "sum" icon
and get a total.
I can place the cursor using VBA, but I can not seem to
find the equivalent of a "sum" command. When I use the macro
recorder it gives a defined range name, which is not useful
since I would like this to work on any column of numbers I want
This seems very simple, but I am struggling with it.