Thread: How to get the value of a meged cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default How to get the value of a meged cell
On Thu, 8 Mar 2007 12:28:34 -0800, nde
wrote:

Hi,

How to get the value of a nerge cell when refering to a address within the
merged Cell.

Exemple:

Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is B1.value (D1.value is
empty)

range("D1").MergeArea.Cells(1).value

--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com
Reply With QuoteReply With Quote