1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I want to create an array of references with variable dimensions

I want to use the index function to pick stuff from an array, but the location and size of that array are subject to change. I tried making an array with address functions, like =index(address(address stuff):address(address stuff)),index stuff) , but that doesnt work. Is there another way to get that array?

submitted by /u/SurgicalWeedwacker
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article