Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Formula/Programming | Excel Worksheet Functions | |||
Excel Formula / Programming | Excel Discussion (Misc queries) | |||
Excel Programming - Formula Assistance | Excel Discussion (Misc queries) | |||
Programming a simple formula | New Users to Excel | |||
Programming A formula | Excel Programming |