Art,

Good solution. Now for the real problem, consider a merged cell with a data value followed by a merged cell having a missing value and there is no means to distinguish the boundary between these two merged cells. Unfortunately the value from the first merged cell will be carried forward into the empty merged cell rows.

Don