•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Vstacking indirects with an array
Hi,
I have an array that gives me the name of every sheet that fits a certain parameter (let’s call this Array 1). I want to use this array vstack array A3# for each sheet. To clarify every single one of the sheets in the Array 1 has an array A3#. Is this possible?
The output I’d like is: Vstack(‘Accounts - A’!A3#, ‘Accounts - B’!A3#, ‘Accounts - C’!A3#, etc.) based on Array 1 which currently spits out: Accounts - A, Accounts - B, Accounts - C, Accounts - D, etc.
[link] [comments]
Want to read more?
Check out the full article on the original site