[算表] excel錄製巨集修改問題?
軟體:excel
版本:2007
我用巨集錄製了一個小程式
Sub Macro7()
'
' Macro7 Macro
'
'
Columns("A:C").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range(
_ "H1:I4"), CopyToRange:=Range("L1:N268"), Unique:=False
End Sub
資料範圍是工作表sheet1的A:C
準則範圍是H1:I4
複製到L1:N268
我想問一下如果準則範圍跟篩選後的結果我要寫在sheet2
然後準則範圍是會變動的(如H1:I4有時候會到H1:I10之類的)
而資料範圍是sheet1的A:C
這邊的巨集我該怎麼改才對？
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.192.197.47
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1414750722.A.A12.html
※ 編輯: ljuber (123.192.197.47), 10/31/2014 18:19:41
→
10/31 19:47, , 1F
10/31 19:47, 1F
→
10/31 19:47, , 2F
10/31 19:47, 2F
→
10/31 19:48, , 3F
10/31 19:48, 3F
→
10/31 20:17, , 4F
10/31 20:17, 4F
→
10/31 20:58, , 5F
10/31 20:58, 5F
→
10/31 20:58, , 6F
10/31 20:58, 6F
→
10/31 20:59, , 7F
10/31 20:59, 7F
→
10/31 20:59, , 8F
10/31 20:59, 8F
→
10/31 21:40, , 9F
10/31 21:40, 9F
→
10/31 21:40, , 10F
10/31 21:40, 10F
→
10/31 21:51, , 11F
10/31 21:51, 11F
→
10/31 22:14, , 12F
10/31 22:14, 12F
→
10/31 22:16, , 13F
10/31 22:16, 13F
→
10/31 22:22, , 14F
10/31 22:22, 14F
→
10/31 22:31, , 15F
10/31 22:31, 15F
→
10/31 22:43, , 16F
10/31 22:43, 16F
→
10/31 23:02, , 17F
10/31 23:02, 17F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
