Programming A formula
 

Hi Bernie,

Unfortunately there re other sheets in there. But they are numbere
like so: Sheet1, Sheet2, Sheet3 etc. The other 231 are name
differently. And unfortunately I got a syntax error from your code? An
ideas?

cheer

--
Josep

-----------------------------------------------------------------------
Joseph's Profile: http://www.excelforum.com/member.php...nfo&userid=563
View this thread: http://www.excelforum.com/showthread.php?threadid=26425

Programming A formula
 

Joseph,

IF your sheets are arranged so that there aren't any Sheet1, etc. sheets
between the sheets you want to sum, then simply

MsgBox Evaluate("=Sum('First Sheet Name:Last Sheet Name'!B2)")

changing First Sheet Name to the actual sheet name of interest, etc.

The syntax error you received was probably due to the extra line break
inserted by our newsreaders.

HTH,
Bernie
MS Excel MVP

"Joseph" wrote in message
...

Hi Bernie,

Unfortunately there re other sheets in there. But they are numbered
like so: Sheet1, Sheet2, Sheet3 etc. The other 231 are named
differently. And unfortunately I got a syntax error from your code? Any
ideas?

cheers


--
Joseph


------------------------------------------------------------------------
Joseph's Profile:
http://www.excelforum.com/member.php...fo&userid=5637
View this thread: http://www.excelforum.com/showthread...hreadid=264258