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!!! |
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) |