View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Multiple sheet #REF

Wouldn't you want something like:
=sum('abx:xlnx'!J4)
to sum those up to 75 cells



Gene wrote:

I have several Worksheets. Up to 75. What is wrong with the following
reference.
=ABX:XLNX!J4
--
GeneS


--

Dave Peterson