更新时间2021-05-28 01:24:51
我的合并单元格合并的行数不一样,前面有序号,怎样做能提取每个单元格对应的序号范围?比如这个,我要获取每个不同合并单元格的对应位置,有没有公式?
自定义函数:
fw(rag)
Public Function FW(rag As Range)
Dim x%, y%, z%, n%
x = rag.Row
y = x + rag.Rows.Count - 1
z = rag.Column
If x = y Then
FW = ""
Else
If Cells(x, z) > Cells(y, z) Then n = x: x = y: y = n
FW = Cells(x, z) & "~" & Cells(y, z)
End If
End Function