Forum Discussion

SukiLuLu's avatar
SukiLuLu
Copper Contributor
Jun 16, 2023

Why does VSTACK work with some pages but not others?

Happy Friday! I'm at my wits end trying to solve this problem.

 

I have a workbook containing 10 sheets. Each sheet is formatted exactly the same and covers exactly the same ranges. I set up page 11 as my "landing" page formatted to align with corresponding data. If I run the formula with sheets 2 thru 6,=VSTACK('2:6'!F71:R79), a correct response is received.

 

However, if I expand my array to cover all sheets,=VSTACK('1:10'!F71:R79) I get #REF in every cell of my "landing" sheet. What am I doing wrong?

Formulas and Functions

7 Replies

Sort By
  • ecovonrein's avatar
    ecovonrein
    Iron Contributor
    Jun 16, 2023

    Does '1:6' work? How about '1:7'? to 8? to 9? What do you get for SUM('1:10'!F71)?

    • SukiLuLu's avatar
      SukiLuLu
      Copper Contributor
      Jun 16, 2023
      Tried 1:6, got #REF again, also the formula changed to=VSTACK('1:[6]6'!F71:R79). I didn't mention this in my post that the formula always comes back with the brackets in the array. What's with the brackets? I also get #REF when trying your other suggestions.

Resources