[算表] 巨集自動刪除陣列內值大於2的該行?
軟體: excel
版本: 2003
巨集卡住了不會寫@@
例如:
Dim ar()
ReDim ar(3,2)
ar(1,1)=1
ar(1,2)=2
ar(2,1)=0
ar(2,2)=-1
ar(3,1)=0.5
ar(3,2)=-2
我想自動判定上述陣列內值大於2的行，並刪除該陣列的該整行，請問該怎做??
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.250.121.43
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1505813454.A.BC9.html
→
09/19 17:55, , 1F
09/19 17:55, 1F
→
09/19 17:55, , 2F
09/19 17:55, 2F
→
09/19 18:29, , 3F
09/19 18:29, 3F
→
09/19 18:29, , 4F
09/19 18:29, 4F
→
09/19 18:31, , 5F
09/19 18:31, 5F
→
09/19 18:33, , 6F
09/19 18:33, 6F
→
09/19 18:34, , 7F
09/19 18:34, 7F
→
09/19 18:35, , 8F
09/19 18:35, 8F
→
09/19 18:38, , 9F
09/19 18:38, 9F
→
09/19 18:39, , 10F
09/19 18:39, 10F
→
09/19 18:39, , 11F
09/19 18:39, 11F
→
09/20 15:31, , 12F
09/20 15:31, 12F
