With your example of B2:E4 does this help?
Sheet14
<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 129px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td>
</td><td>A</td><td>B</td><td>C</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>
</td><td>Row</td><td>Column</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td>No of rows</td><td style="text-align: right;">3</td><td style="text-align: right;">4</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td>Start</td><td style="text-align: right;">2</td><td style="text-align: right;">2</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td>End</td><td style="text-align: right;">4</td><td style="text-align: right;">5</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0); width: 196px; height: 156px;"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt; width: 179px; height: 116px;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B2</td><td>=ROWS(Sheet1!$B$2:$E$4)</td></tr><tr><td>C2</td><td>=COLUMNS(Sheet1!$B$2:$E$4)</td></tr><tr><td>B3</td><td>=ROW(Sheet1!B2:E4)</td></tr><tr><td>C3</td><td>=COLUMN(Sheet1!B2:E4)</td></tr><tr><td>B4</td><td>=B2+B3-1</td></tr><tr><td>C4</td><td>=C2+C3-1</td></tr></tbody></table></td></tr></tbody></table>
That would be all OK if I didn't think that someone might inadvertently mis-key the B2:E4 and so I was hoping for a formula that would be like this so that there is only one instance of the range names stored in the CELL formula in column A:
<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; width: 481px; height: 97px;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 129px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td>
</td><td>A</td><td>B</td><td>C</td><td style="vertical-align: top;">D
</td><td style="vertical-align: top;">E
</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>Address
</td><td>RowStart</td><td>RowEnd</td><td style="vertical-align: top;">ColStart
</td><td style="vertical-align: top;">ColEnd
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td>[Test.xls]Sheet1!$B$2</td><td style="text-align: right;">2</td><td style="text-align: right;">4</td><td style="vertical-align: top;" align="right">2
</td><td style="vertical-align: top;" align="right">5
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td>[Test.xls]Sheet1!$A$10</td><td style="text-align: right;">10</td><td style="text-align: right;">16</td><td style="vertical-align: top;" align="right">1
</td><td style="vertical-align: top;" align="right">6
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td>[Test.xls]Sheet2!$C$2</td><td style="text-align: right;">2</td><td style="text-align: right;">4</td><td style="vertical-align: top;" align="right">3
</td><td style="vertical-align: top;" align="right">5
</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0); width: 196px; height: 156px;"><tbody><tr><td>
Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" width="226" border="1" cellpadding="2" cellspacing="0" height="169"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>A2</td><td>=CELL("address",Sheet1!B2:E4)</td></tr><tr><td>B2</td><td>=ROW(INDIRECT(A2))</td></tr><tr><td style="vertical-align: top;">C2
</td><td style="vertical-align: top;">=COLUMN(INDIRECT(A2))
</td></tr><tr><td>D2</td><td>=
LASTROW(INDIRECT(A2))</td></tr><tr><td>E2</td><td>=
LASTCOLUMN(INDIRECT(A2))</td></tr><tr><td>A3</td><td>=CELL("address",Sheet1!A10:F16)</td></tr><tr><td valign="top">B3
</td><td valign="top">=ROW(INDIRECT .... etc
</td></tr></tbody></table></td></tr></tbody></table>