1004 Run-time error
I tried doing a search for this error message, but couldn't find one related to my problem, so here goes.
Running Excel 2000 here and this macro (snippet below) has been running fine on several machines. Suddenly, this one machine in particular has been getting a 1004 Run-time error (With statement).
I have an idea what the problem is, but the thing that gets me is this code still successfully works on several other machines at my work place.
I know the code is sloppy, as you'll see below. I'm simply trying to fix something that was already in place before I got here. I'll definitely clean it up once I get it working.
Any ideas? Thanks in advance for the help.
--
Sub maketable()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
DirPathVars
Workbooks.Add
With Application
.DefaultFilePath = DPTH1 & DPTH11
.SheetsInNewWorkbook = 1
Cells.Select
.StandardFont = "Century Schoolbook"
.StandardFontSize = 8
Selection.ColumnWidth = 2
Selection.RowHeight = 13 '13
End With
....
