How can i decide whether a range of cells are merged or not?

Mar 13th, 2002, 07:31 AM

Pls.... help

Audiojoe · Mar 13th, 2002, 07:41 AM

You can right click on the suspected area, then choose Format Cells. Go to the Alignment Tab, and if there is a tick in the Merge Cells box then they're merged

Mar 13th, 2002, 07:42 AM

The MergeCells property will tell you whether there are any merged cells in a range.

Barry Katcher · Mar 13th, 2002, 07:47 AM

Barry Katcher · Mar 13th, 2002, 07:49 AM

When you click on any of the suspected cells, if they are merged, the cell outline will include all of them. If you have your grid turned on, the grid will show you which cells are merged.

Mudface · Mar 13th, 2002, 07:51 AM

The function below will return true or false if any cells are merged within the range you want to check: -

Public Function IsItMerged(myRange As Range) As Boolean
Dim c As Range

For Each c In myRange
If c.MergeCells Then
IsItMerged = True
Exit Function
End If
Next c

IsItMerged = False

End Function

Mar 13th, 2002, 08:05 AM

Thx all, Thx Mudface!!! That's the answer

Even though i haven't state the question clearly, you can get what i mean!! Great!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 07:41 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	You can right click on the suspected area, then choose Format Cells. Go to the Alignment Tab, and if there is a tick in the Merge Cells box then they're merged

Mar 13th, 2002, 07:42 AM	#3
Guest Posts: n/a	The MergeCells property will tell you whether there are any merged cells in a range.

Mar 13th, 2002, 07:47 AM	#4
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038

Mar 13th, 2002, 07:49 AM	#5
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038	When you click on any of the suspected cells, if they are merged, the cell outline will include all of them. If you have your grid turned on, the grid will show you which cells are merged.

Mar 13th, 2002, 07:51 AM	#6
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	The function below will return true or false if any cells are merged within the range you want to check: - Public Function IsItMerged(myRange As Range) As Boolean Dim c As Range For Each c In myRange If c.MergeCells Then IsItMerged = True Exit Function End If Next c IsItMerged = False End Function

Mar 13th, 2002, 08:05 AM	#7
Guest Posts: n/a	Thx all, Thx Mudface!!! That's the answer Even though i haven't state the question clearly, you can get what i mean!! Great!!