Hellow.

Is there a way of using the lookup and reference functions to simulate a currentregion?

The ideal scenario would be the user selecting just one cell (maybe the first one), and using only worksheet functions, being able to determine the number of row and columns to get the whole reference for using in vlookups and the like.

I was wondering if it can be done.

Thank you.