Excel 2013, VFP9SP2
Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx
I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire column, Excel tells me the SUM of all of the values in the column at the bottom. I need that number. I don't want to do some sort of loop; rather, I want to basically say from VFP: 'return the SUM("R:R").' I've looked at the object model above and there doesn't appear to be a .Sum to tag onto the end of the Range object (like you might think of with DotNet stuff). Also, I don't want to create a formula in some other remote cell and then read that, although that's my Plan B for now.
Ideas?
tia! --Mike