Simulate currentregion without vba? (or getting row and col count using functions)

[El_Servas]

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.

[WHER]

Not sure, maybe this can give you some ideas.

[El_Servas]

Interesting. Will take a look a it.
Thank you for replying.