View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
TH[_3_] TH[_3_] is offline
external usenet poster
 
Posts: 38
Default VBA: How to detect whether two cells are currently merged

Go to Excel HELP and type
mergecells property
In the Answer Wizard section.

TH

Cells(ActiveCell.End(xlDown).Row + 1, ActiveCell.Column).Select

On 4/15/04 15:40, in article , "Lazer "
wrote:

Using VBA, how can I determine whether two cells (let's say F8 and F9.
for example) are currently merged?

Thanks!
Eliezer

---
Message posted from
http://www.ExcelForum.com/