66问答网
所有问题
当前搜索:
excel隔列加空列
EXCEL
多行重复数据查找
答:
1) = 12 And arr(x + 2, 1) = 5 Then i = i + 1 ReDim Preserve arr1(1 To i)arr1(i) = arr(x, 1)End If Next x Range("B1").Resize(UBound(arr1), 1) = Application.Transpose(arr1)End If End Sub 你在A
列加
添加数据下试试,或修改单元格的值试下,自动运行 ...
excel
循环判断语句 使用
答:
Sub 宏名称()Dim x For x = 2 To 30 Step 1 If Sheet1.Cells(x, 1) <> "" Then Sheet2.Cells(x, 1) = Sheet1.Cells(x, 1)Sheet2.Cells(x, 2) = Sheet1.Cells(x, 3)End If Next Dim y For y = 2 To 30 Step 1 If Sheet2.Cells(y, 1) = "" Then Sheet2.Rows(...
棣栭〉
<涓婁竴椤
25
26
27
28
29
30
31
32
33
76
其他人还搜