Suppose you have two dynamic ranges, myHdrRow that resolves to D1:H1, and myHdrCol that resolves to A5:A10.
In VBA, you can easily get the body area of the table defined by the extents of the header row and column:
How would you define a dynamic range in the same fashion via the UI?![]()
Set rTbl = Intersect(Range("myHdrCol").EntireRow, _ Range("myHdrRow").EntireColumn)
Bookmarks