Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming A formula
Hi all, I need to be able to sum one cell (B2) in 231 sheets programmatically Any 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 the 231 sheets are all the sheets that are in the workbook: MsgBox Evaluate("=Sum('" & Worksheets(1).Name & ":" & Worksheets(Worksheets.Count).Name & "'!B2)") Otherwise, you will need to change how the formula is structured, or do a loop.... HTH, Bernie MS Excel MVP "Joseph" wrote in message ... Hi all, I need to be able to sum one cell (B2) in 231 sheets programmatically. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming A formula
1 way.
Insert a sheet at the front called A and one at the end called Z then =SUM(A:Z!B2) R Pete -- (][ This Email has been scanned by Norton AntiVirus. ][) "Joseph" wrote in message ... Hi all, I need to be able to sum one cell (B2) in 231 sheets programmatically. 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 | |||
Formula causing run-time error in Excel Programming | Excel Worksheet Functions | |||
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 |