How to get first left cell position and bottom right cell position from a table

[Mathman]

What I'm try to accomplish.

I am pulling ranges from an excel file using python then creating an image. These are not set data tables, could have combo of number/text/empty cells. Now using Python I can manually input the 2 requirements needed, first top left cell then first right bottom cell but I need it to be dynamic.

Example area B4:F20 The thing is any of the 4 variables can change.

Can I do

somethin(B4) = B4? I can then do a column list with these start/end points in a separate sheet and they will not move and I can call it into a dataframe.

Here's' a post and all pictures are generated from excel. The black boarders are a column and row blacked out, These are the outer cells I need to call and be dynamic.
Examples of pictures taken from excel

Thank you

Help

 

[NoSparks]

This of any use, can be any cell within the table
MsgBox Range("B4").ListObject.Range.Address(0, 0)

 

[Mathman]

Your reply helped me get to this. Turns out it was rather simple just wasn't aware of this feature.

=CELL("address",B4)

Thanks again, this really helps me out a lot!
MM