Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#REF error
When using a formula to pull all h24 cells from each worksheet i am getting a
#REF error. This is the formula =INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24"). Is there a better formula? How can I correct this error?? Any help would be greatly appreciated!!! |
#2
|
|||
|
|||
I don't understand exactly what you're trying to do.
If you have sheets 1 to 10, when you say "pull", do you mean *display each* sheets content of H24 down a column, one cell per sheet? =INDIRECT("'SHEET"&ROW(A1)&"'!H24") And copy down for 10 rows, one for each sheet. OR Do you mean total (add) all the H24 cells from each sheet and display it in a single cell: =SUM(Sheet1:Sheet10!H24) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Todd Nelson" wrote in message ... When using a formula to pull all h24 cells from each worksheet i am getting a #REF error. This is the formula =INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24"). Is there a better formula? How can I correct this error?? Any help would be greatly appreciated!!! |
#3
|
|||
|
|||
This looks for sheet names like: sheet2, sheet3, sheet4, ...
Are those the names of your worksheets? Todd Nelson wrote: When using a formula to pull all h24 cells from each worksheet i am getting a #REF error. This is the formula =INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24"). Is there a better formula? How can I correct this error?? Any help would be greatly appreciated!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |