VBA: How to detect whether two cells are currently merged

Posted to microsoft.public.excel.programming

TH[_3_]

external usenet poster

Posts: 38

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/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy paste non merged to merged cells	[email protected]	Excel Worksheet Functions	1	February 5th 09 05:25 PM
How can I sort an Excel Doc containing merged & non-merged cells?	KellyH	Excel Discussion (Misc queries)	11	June 10th 08 04:12 AM
Autofit Merged cell Code is changing the format of my merged cells	JB	Excel Discussion (Misc queries)	0	August 20th 07 02:12 PM
how do i link merged cells to a merged cell in another worksheet.	ibbm	Excel Worksheet Functions	3	April 27th 06 11:40 PM
Sorting merged cellsHow do I sort merged cells not identically siz	Laval	Excel Worksheet Functions	1	November 3rd 04 09:40 PM

All times are GMT +1. The time now is 01:54 AM.

About Us