Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004': Select method of Sheets class failed
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004': Select method of Sheets class failed | Excel Programming | |||
Run-time error '1004': Select method of Range class failed | Excel Programming | |||
Select method of range class failed, Run time error 1004 | Excel Programming |