On Mar 7, 9:54 pm, "Jim Cone" wrote:
Pam,

why the minus 1 ...
On a worksheet, enter this equation in cell AM10 and see what happens.
= Sum(AM2:AM10)
--
Regards,
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware

"Pam"
wrote in message
Hello Jim Cone:
Thank you so much it worked! The only thing I had to do was increment
rwindex = rwindex + 1 to put the total in the row I wanted it to be
on.
Question what does the -1 do ? I did testing to try to figure it out
by change it to + 1 or even taking it out
Again Thank You, I was close but not on the money.
Pam

Jim:


Ok, another question for you. I tried everywhich way to maek this
work. My row is never the same because it depends on how many row are
in the spread sheet. Can you tell me what I amdoing wrong for this
range?


Range("AM:AQ" & rwindex) I am trying to get ranges Am through AQ:
I also tried
Range("AM & rwindex:AQ" & rwindex)
but it still does not work for me.



Thanking You in advance.
Pam