Hi,

I created a vba code to sum values in several columns. Column "D" thru
"O" the code works when ran I see the correct values. Now lets say my
code is placed in E18 and the formula is Sum(E15:E17) and the code
will be similar for the other columns. There is a empty cell above and
below the range I'm using. The value like I said is correct, until I
do a save and now the formula show the range extended like this
Sum(E13:E17). Now there is a value in E13, but I do not want that to
be added to my total in E18.
I'm using Excel 2007.

Any thought would be appreciated.