VBA Sum a Row of Data

[Gian624]

Hello,

I need to use VBA to sum a set of data on a row. The data is in cells B2 through M2. In the example, I have to use A1 as the range start point and use an offset to get me to cell B2. I then need to use the xlToRight function as the range to sum. I was thinking about using a with statement with the range as A1. I can't figure out how to sum the data from there.

Thanks for your help.

 

[Gingertrees]

Your Object Browser can be a big help with syntax.
Offset is a member of the Range class.
xlToRight is a member of the Range.End class

Sum is not easy to do across a range in VBA - I'd probably establish names for the start and end of the range to be summed, then set cell (e.g.) A3="=sum(" & name1 & ":" & name2 & ")" . For clarity, I'd make the cell above this say something like "=total:". But unsure what your assignment allows/disallows.