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!