I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!

hi Huber57

See
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Huber57" wrote in message ...
I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!

Put a sheet called Start & end as the first and last sheets. Hide them if you
want and then this sums a1 in every sheet

=SUM(Start:End!A1)

Mike

"Huber57" wrote:

I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!

Ron and Mike,

thanks much!

"Mike H" wrote:

Put a sheet called Start & end as the first and last sheets. Hide them if you
want and then this sums a1 in every sheet

=SUM(Start:End!A1)

Mike

"Huber57" wrote:

I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!