Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named Ranges and VBA Add-ins | Excel Programming | |||
Named Ranges and VBA Add-ins | Excel Programming | |||
Named Ranges and VBA Add-ins | Excel Programming |