On 13 Feb, 14:44, "Tom Ogilvy" wrote:
Are the names correct?

Are any of the sheets hidden?

--
Regards,
Tom Ogilvy

"Sol" wrote in message

ps.com...



Hi all

I get the error - Run-time error '1004': Select method of Sheets class
failed
When I go to debug I get 1st and 2nd line highlighted in yellow

Sheets(Array(" Summary", "Transaction Register", "Investrep",
"Cashflow", _
"Charts")).Select
Sheets(" Summary").Activate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("PRINTING").Select
Range("A1").Select
End Sub

Any ideas on how to remedy this please

Cheers

Sol- Hide quoted text -

- Show quoted text -

Yes it turns out that one sheet was hidden, I revealed it and all
printed ok...many thanks