Sum a Range of Cells

[wutzke]

I have sets of cells that are maybe 7 columns wide by 5 rows deep,
followed by another 12 columns wide by 2 rows deep, then another just
5 rows by 5 columns.

Something similar to
http://spreadsheets.google.com/ccc?key=p5XvDvb4SUVgeQHRycNcWUQ&hl=en

How would I create a function that passes the sum of any grid to a
varable, no matter the dimension of the grid?

 

[Bob Phillips]

myVar = Application.Sum(Activecell.CurrentRegion)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[wutzke]

myVar = Application.Sum(Activecell.CurrentRegion)

thanks that was great help

 

[wutzke]

Thanks Bob.