I'm looking for some code for a VB Script so I can autoformat a worksheet in excel. I tried using the macro recorder and got the following code but I can't get it to run properly.
It doesn't have to use the code I have below I am just looking for somethign so I can format my worksheets.
"ie" is Set ie = CreateObject("excel.Applic
ie.Selection.AutoFormat Format:= xlRangeAutoFormatClassic3, Number:=True, Font:=True, Alignment:=True, Border:=True, Pattern:=True, Width:=True