Forum Discussion
GregGann
Mar 02, 2022Copper Contributor
How do I access #SPILL area from FILTER() result in VBA?
If I use FILTER() function cell $B$1, how do I target or select the entire spill range from VBA?
There is a range or table. It is outlined in blue. The blue outline updates dynamically with the number of lines returned as the FILTER() arguments are changed.
There is no explicit variable in the Name Manager (as happens when tables and print areas are defined, for example).
In the docs.microsoft.com Office VBA references, there are the FILTER and FILTERS objects. Both then refer to AUTOFILTER, so I am unsure if this will also apply to the results generated by FILTER()
Are there any ideas or suggestions?
- Use the # character, so $B$1#
6 Replies
- mtarlerSilver ContributorUse the # character, so $B$1#