Good morning!
I have some people on my staff that have Excel 2007; others have Excel 2003. I have a worksheet template that has a print macro that seems to work on the users with Excel 2007, but it doesn't work with Excel 2003 but I can't figure out what. The error I get is "Run-time error 1004: You've entered too many arguments for this function"
Here is the macro code in question:
Sub PrintSumm()
'
' PrintSumm Macro
'
'
Range("A1:L27").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$L$27"
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Range("A20:K27").Select
End Sub
Bookmarks