View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Wood Grafing Wood Grafing is offline
external usenet poster
 
Posts: 57
Default How to get the value of a meged cell

You answered your own question he


"nde" wrote:


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)