I’m new to Excel VBA and was wondering if there is a way to retrieve the entire range of a dynamic array table (like a CSE array) given an address of a specific cell that is known to be inside that range ?

say I have a dynamic array table given an address of a single cell how can I determine the range of the entire table ?