Public Sub ClearCellArray(ByVal sheetName As String, ByVal pos As Variant) For Each P In pos Sheets(sheetName).range(P).value = "" Next End Sub Public Sub ClearLine(ByVal sheetName As String) For Each x In Sheets(sheetName).Shapes If x.Type = msoLine Then x.Delete End If Next ...
(ptName) If Not pt Is Nothing Then pt.TableRange2.Clear ' 清除数据透视表内容 ws.PivotTables(ptName).Delete ' 删除数据透视表 End If On Error GoTo 0 ' 创建数据透视缓存 Set pc = ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=dataRange) ' 创建数据透视表 Set pt = pc...
Err.Clear' 清除错误EndIfNexti MsgBox strListEndSubSubtry1()Callm1(23, 24, 25)' iInput=23, argArr(0)=24, argArr(1)=25Callm1(23, 24, , 25)' iInput=23, argArr(0)=24, argArr(1)=缺失参数, argArr(2)=25Callm1(23, 24, 64.4, 25, "data")' iInput=23, argArr(0)=24, a...
'粘贴到PowerPoint mySlide.Shapes.PasteSpecialDataType:=10 '2 = ppPasteEnhancedMetafile Set myShape =mySlide.Shapes(mySlide.Shapes.Count) '设置位置: myShape.Left = 15 myShape.Top = 15 myShape.Width = 690 End If Next ws '使PowerPoint可见并激活 PowerPointApp.Visible = True PowerPointApp.Activate '...
Sub 统计数据() Dim data As Variant data = Array(Array("Sales", 100), Array("HR", 200), Array("Sales", 150), Array("IT", 100), Array("HR", 250)) Dim dict As Object Set dict = CreateObject("Scripting.Dictionary") Dim i As Integer For i = LBound(data) To UBound(data) If...
= "" Then'未选择法人，则生成所有法人的For Each Key In dic.keysk = 0fileName = KeyCall WriteArray(arr1, arr2)If Me.OptCurrentTable ThenCall CopyWorksheet(wsSource, fileName)Set wsTarget = wb.Sheets(fileName)extraLines = UBound(arr1) - (tbLastLine - tbFirstLine + 1)Call WriteData...
Sub CopyDataByArray() Dim arr As Variant Dim i As Long Dim j As Long Dim row As Long row = 1 arr =Sheet4.Range("A1").CurrentRegion.Value For i = LBound(arr) To UBound(arr) If arr(i, 1) = "完美Excel" Then For j = LBound(arr, 2) ToUBound(arr, 2) ...
Set dt = Sheets("tdata") dt.[a1:ab70].ClearContents ws.[a1].CurrentRegion.Copydt.[a1] dt.Activate [g1] = [b1] v =Split([a1].CurrentRegion.Address, "$")(4) Range("b1:b"& v).AdvancedFilter xlFilterCopy, [g1:g2], [k1], True For ...
Set dt = Sheets("tdata") dt.[a1:ab70].ClearContents ws.[a1].CurrentRegion.Copy dt.[a1] dt.Activate [g1] = [b1] v = Split([a1].CurrentRegion.Address,"$")(4) Range("b1:b" & v).AdvancedFilterxlFilterCopy, [g1:g2], [k1], True ...
My question, can someone please show me how to 'reshape' the range above so it fits the array below ReDim Preserve DataArray(0 To n, 0 To 5, 0 To 1) Data_Array Data_Array(0) "Item_1" Data_Array(0,0) Data_Array(0,0,0) "100" ...