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 |
All times are GMT +1. The time now is 09:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com