After trying a few options and searching for the last couple hours can't seem to find a way to have a dynamic named range that will select the cells in Column B if the corresponding value in Column A is equal to a specific value ("Y"). Any info on how I could accomplish this is appreciated. FYI, I am generating the dynamic named range specifically to identify cells to clear the values from in a macro. Thanks.
Cross Post on MrExcel
Bookmarks