It is not clear what you are trying to do.
Merged cells and macros often do not work well together.
Helpful posting advice here...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
wrote in message
How do I create a macro to hide rows that contain merged cells with
hiding all rows that are contained in the merge?