A few weeks ago I watched a YouTube video showing how to take a Range of Cells and copy them to a Names Manager Constant.

I believe the example was showing how to remove a VLookup Table by simply copying it to a Constant Named Range. I believe you could then remove the "Refers to:" part of the named range.

I can't seem to find where this YouTube video is or how to perform this magic. It might have been an addenda to CSE formulas and how to make Named Range Constants using them.

Can you find that link or tell me how to do this?