drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!
I do not want to use VBA
I have a table in a sheet
The table name is Table1
This table may contain X rows and Y columns
=CELL("address";Table1) is giving me only the upper left cell address so $B$5
and I am expecting to get B5;Z450 or $B$5:$Z$450
I do not want to use VBA
I have a table in a sheet
The table name is Table1
This table may contain X rows and Y columns
For this eg: B5;Z450.
How Can I use a Formula to get this table range address ??=CELL("address";Table1) is giving me only the upper left cell address so $B$5
and I am expecting to get B5;Z450 or $B$5:$Z$450