using named ranges
I have a grid for which I would like to return the intersection of
each row and column into a list below the grid.
The left-most row and the top-most column contain the names for each
respective row or column.
How can I switch the formula below from using the name itself to using
the name that is contained in the cell so that I can loop through the
entire grid?
Range("a24").Value = Application.Intersect(Range("sample_2"), Range
_("sample_1"))
where cell A2 contains "sample_2" and cell B2 contains "sample_1"
TIA
|