I have recorded a macro to print select sheets in a workbook and have hidden the sheets but when i want to print the specified sheets i get this error:
Run-time error '1004'
select method of sheets class failed
Any ideas on how to resolve this error besides having the sheets be visible ?
This message was edited by royhern on 2002-09-25 18:07
Run-time error '1004'
select method of sheets class failed
Any ideas on how to resolve this error besides having the sheets be visible ?
This message was edited by royhern on 2002-09-25 18:07