View Full Version : Solved: Cell Reference, No VBA Required

Anne Troy
06-29-2005, 06:18 PM
I can never remember how to do this.

Suppose I have a worksheet name in cell A2 (which I do).

Suppose in C2, I want to SUM(C2:C65536) from the worksheet whose name is in A2.



Jacob Hilderbrand
06-29-2005, 06:38 PM

Anne Troy
06-29-2005, 06:47 PM
Thanks, Jake. Now why the heck do I always try to put the quotes on the first part instead of the second?? Geesh!!

Jacob Hilderbrand
06-29-2005, 07:39 PM
Glad to help. :beerchug:

Take Care