Active Member
August 15, 2023
I have been using vstack for a little while and came across a problem last night. I went to perform the function with a 3d reference of all the sheets and the formula returned a single 0 in the cell vstack was typed in.
This is also the same if I reference each page individually. However works on a single page.
Anybody else come across this issue?
(Sorry I can't put an example workbook up)
Moderators
January 31, 2022
Active Member
August 15, 2023
Hi thank you for the reply. Yes this is what I am trying to achieve. I have done the same formula for over 100 sheets before and worked OK.
The work around I have found so far is to take the work book where v stack doenst work, power query all the sheets into a new workbook mirroring the same format and layout, then apply the vstack and it works perfectly.
Tried this on 3 separate workbooks (one of which had over 170 sheets) and the work around holds.
Still can't figure out why it only works in this method now
1 Guest(s)