軟體:excel
版本:2007
我有一個表
A x
A x
A y
B y
B x
C k
C k
C x
D x
D x
D y
想要儲存格合併的時候
B欄位依照A欄位合併
現在的巨集會變成B欄位的就合併一起
檔案如附件:
https://drive.google.com/open?id=1HC3AC-tunGI2MTeLfxkEtE_f0dcT0ZeL
我用巨集如下
Dim xR As Range, xH As Range
For Each xR In Range([A1], [A65536].End(xlUp))
If xR <> xR(0) Then Set xH = xR
If xR <> xR(2) Then Range(xR, xH).Merge
Next
For Each xR In Range([b1], [b65536].End(xlUp))
If xR <> xR(0) Then Set xH = xR
If xR <> xR(2) Then Range(xR, xH).Merge
Next
不知道這塊要怎麼改