View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
 
Posts: 177
Default 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?