Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if sheet contains mergearea(s)
Is there any way to determine if a sheet contains mergearea(s) without
checking individual cells for MergedCell? tia, dk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if sheet contains mergearea(s)
Sub test()
Dim bGotMergedCells As Boolean Dim vMerged As Variant vMerged = ActiveSheet.Cells.MergeCells bGotMergedCells = IsNull(vMerged) Or vMerged MsgBox bGotMergedCells End Sub Regards, Peter T "dk" wrote in message ... Is there any way to determine if a sheet contains mergearea(s) without checking individual cells for MergedCell? tia, dk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if sheet contains mergearea(s)
If cells.MergeCells = Null then
' contains merged cells elseif cell.MergeCells = True then ' whole sheet is one big merged cell elseif cell.MergeCells = False ' no merged cells End if -- Regards, Tom Ogilvy "dk" wrote: Is there any way to determine if a sheet contains mergearea(s) without checking individual cells for MergedCell? tia, dk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if sheet contains mergearea(s)
that first line should be
if isNull(cells.MergeCells) then -- Regards, Tom Ogilvy "dk" wrote: Is there any way to determine if a sheet contains mergearea(s) without checking individual cells for MergedCell? tia, dk |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if sheet contains mergearea(s)
Thanks
"Tom Ogilvy" wrote: that first line should be if isNull(cells.MergeCells) then -- Regards, Tom Ogilvy "dk" wrote: Is there any way to determine if a sheet contains mergearea(s) without checking individual cells for MergedCell? tia, dk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine what sheets are linked to sheet A | Links and Linking in Excel | |||
Content cell to determine which sheet to look at | Excel Discussion (Misc queries) | |||
How do I determine automatically that a sheet is empty? | Excel Worksheet Functions | |||
How to determine an opened sheet( Read Only) | Excel Programming | |||
determine what sheet user is viewing | Excel Programming |