=INDIRECT(CHAR(MAX(CODE(LEFT("A1:F5",1)),CODE(LEFT("C1:H3",1))))&CHAR(MAX(CODE(MID("A1:F5",2,1)),CODE(MID("C1:H3",2,1))))&":"&CHAR(MIN(CODE(MID("A1:F5",4,1)),CODE(MID("C1:H3",4,1))))&CHAR(MIN(CODE(MID("A1:F5",5,1)),CODE(MID("C1:H3",5,1)))))
代表C1:F3的区域
会用自定义函数吧?
Function INRAN(RAN1 As Range, RAN2 As Range) As String
INRAN = Application.Intersect(RAN1, RAN2).Address
End Function
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024