EXCEL 宏问题 怎么选中动态的多个单元格?答:[a1].Resize(i, 3).Select 和 Range("A1:C" & i).Select 如不是 A1 开始, 是 A2开始, 将 A1 改成 A2便可 亦可写成 [A2].Range(Cells(1,1),cells(i,3)).select 或 Range(Cells(2, 1), Cells(i, 3)).Select 上述所有方法, 都是最基本及经常用的VBA语法, 非常重要 ...
excelVBA 要随机的排序,要怎么写代码丫答:Sub test()Dim ar(), br(), cr(), tempr1(), tempr2()Dim i, j, k, n As Longar = Array("Shell", "Case", "Cover", "Backcover", "Back Cover", "housing", "Skin", "protection", "protector", "Protective", "Pouch", "Flip", "Holster", "Wallet", "...