知識收集站

excel建立圖表、排序、篩選重複值vba金融分析師 excel建立圖表、排序、篩選重複值vba '====建立圖表========' ActiveSheet.Shapes.AddChart.Select'' With ActiveChart' .ChartType = xlColumnStacked' .SetSourceData Source:=Sheets("Sheet2").Range("B2:c5"), PlotBy:=xlColumns' End With'========advancedfilter======'Dim adra As Range'Set adra = [e1:e5]'adra.AdvancedFilter Action:=xlFilterCopy, _' CopyToRange:=Range("f1"), Unique:=True'order============================'Dim aasf As Range'Set aasf = Worksheets("sheet9").Range("e10:f16")' aasf.Sort key1:=[e10], Order1:=xlDescending, Header:=xlNo, Orientation:=xlTopToBottom'===='Application.OnTime Now() + TimeValue("00:00:05"), "sheet8.a11"CalculateAutoRunTime = Now + TimeValue("00:00:01")Application.OnTime AutoRunTime, "test"