D列等于C列在右侧相对应的名称,, 右侧对应的项目,要在宏中显示,不显示在表格的.要求:使用宏命令,不要公式. 以下命令,总是会把A和B列的数据复制到C和D列.但是把A和B列的数据清空,以下公式,又运行正常, 请求大神帮忙 修改一下. Sub test_1() DimA, B, i, j A =Array("DG1=(01,53,58,41,40,44,52)", _ "DG2=(43,49,45,46,42)", _ "DG3=(16,28,80,19,55)", _ "GM1=(21,23,93,32,33,22,95,68)", _ "GM2=(05,81,06,61,31,03,10,11)", _ "GM3=(02,24,47,54,13,08,94)", _ "GM4=(14,12,20,15,17,18,07,09,70)", _ "FR1=(56,38,57,39,48,77)", _ "FR2=(75,86,76,91,79,72)") B =[c1].CurrentRegion Fori = 2 To UBound(B) For j = 0 To UBound(A) If InStr(A(j), Format(B(i, 1), "00")) Then B(i, 2) =VBA.Split(A(j), "=")(0): Exit For Next j Nexti [c1].Resize(i - 1, 2) = B
End Sub
|