J Joseph Sep 28, 2004 #1 Hi all, I need to be able to sum one cell (B2) in 231 sheets programmatically Any ideas? cheer
B Bernie Deitrick Sep 28, 2004 #2 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, 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
O OZDOC1050 Sep 28, 2004 #3 1 way. Insert a sheet at the front called A and one at the end called Z then =SUM(A:Z!B2) R Pete
