Summary page
 

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!

Summary page
 

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!

Summary page
 

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!

Summary page
 

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!