PDA

View Full Version : [SOLVED] Count how many cells have been merged to make one cell.



crmpicco
05-19-2005, 02:33 AM
I am looking for code that will count how many cells have been merged to make one cell.


Thanx.

Picco

Emily
05-19-2005, 02:59 AM
[AnyCell_in_Your_MergeArea].MergeArea.Cells.Count

Example


TotalCell = [H5].MergeArea.Cells.Count