Jump to content
Sign in to follow this  

Count of the number of rows in a merged cell in MSexcel

Recommended Posts


I have to automate a few tasks to be carried out on an excel sheel (MS office 2010).

There are quite a few merged cells in the excel file I have to use. For one of the tasks, I need to know the number of rows which are merged to a single cell.

Can someone kindly help me out here :)



Share this post

Link to post
Share on other sites

Hello and welcome,

If you haven't already please make sure to check the help files for Excel automation. There are also User Defined Functions or UDF's for short out there for this very thing. Make sure to do a good search of the forum or use the google site search. I find that the later is sometimes better.


Here's a link to one such UDF

Here's the function from that link that pertains to merging / unmerging cells

_ExcelCellMerge(), for merging (or unmerging) together all cells of a given range

Edited by Attckdog

A true renaissance man

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...