All,
I have the code below designed to remove any picture objects, reset the font, and delete some blank cells and some columns. I have it looping in a folder with about 52k workbooks that need to be modified. Unlike my other macros,this one has been running for 3 days and still isn't done. Is there something in the code that could be causing delays? The sheets are less than 100k in size each.
Thanks!
![]()
Sub New_Clean() ' ' Macro2 Macro ' Dim PathName As String Dim FileName As String Dim CurrentWB As Workbook Dim Pic As Object PathName = "C:\BoxScoreTest\" FileName = Dir(PathName & "*.xls") Do While FileName <> "" Set CurrentWB = Workbooks.Open(PathName & FileName) With CurrentWB.ActiveSheet .Rows("1:30").Delete Shift:=xlUp With .UsedRange.Font .Name = "Verdana" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .TintAndShade = 0 .ThemeFont = xlThemeFontNone .ColorIndex = xlAutomatic ActiveWindow.SmallScroll Down:=-120 Range("A1:BR500").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.Delete Shift:=xlToLeft Columns("I:BX").Select Selection.Delete Shift:=xlToLeft Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove For Each Pic In ActiveSheet.Pictures Pic.Delete Next Pic End With End With CurrentWB.Close True FileName = Dir() Loop End Sub
Bookmarks