excel megoldás?

[Sass Róbert]

Eszli írta:
>  Létezik olyan eljárás, ami az adott helyen végigellenőrzi, és jelzi,
> hol van az egyesítés?

http://www.google.hu/search?hl=hu&q=excel+find+merged+cells&btnG=Google+keres%C3%A9s&meta=&aq=f&oq=
=>
http://www.mrexcel.com/forum/showthread.php?t=74144
=>

Sub findmerged()
    Dim c
    For Each c In ActiveSheet.UsedRange
        If c.MergeCells Then
            MsgBox c.Address & " is merged"
        End If
    Next
End Sub

vagy

To find a merged cell in Excel 2003.

1. Open a Find and Replace Menu.
2. Next to the Find What Field is a Format Box, Click it.
3. This opens the Find Format Menu screen which looks very similar to
the Cell Format Tabs and screens
4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to
Fit boxes.
5. Leave a tick in the Merge Cells Box and click the OK Button to return
to the Find and Replace screen.
6. Now click the Find All Button and ALL merged cells are shown in the
lower window and are selectable to jump to their location.