Count number of rows in a merged cell

[Rude Awakening]

Is there a simple way(or the simplest way) to count the number of rows a merged cell takes up.

So if I'm in A1, and cells B1:B5 are merged, I want to be able to say in A1 that merged cells B1:B5 take up 5 rows.

Thanx

 

[Fluff]

Something like

MsgBox Range("B1").MergeArea.Rows.Count

But merged cells are an abomination & should be avoided like the plague.

 

[Rude Awakening]

Yea exactly that, cheers

 

[Fluff]

You're welcome