The TestSmartMarkers file is template file，I merge A3 and B3 and want to get a result like ExpectedResult, the A3 B3 A6 B6 A10 B10 can automatically be merged when expanded by subtotal9 formula.
SubTotalMerge.zip (126.0 KB)
Above SubTotalMerge is a simple sample code, the ExpectedResult file is what I want to implement
the OutPut file is result now.
Hope your reply, thank you!