ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Range of a merged cell (https://www.excelbanter.com/excel-worksheet-functions/110022-range-merged-cell.html)

~L

Range of a merged cell
 
Is there a function that returns the range covered by merged cells? For
example, if A1 through A5 are merged, what function would return A1:A5 if one
of the cells in the range is referred to?


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com