Runtime error 1004

[Ninzzii]

Hello,

Please could someone help me resolve Runtime error 1004? I can't get my head around it. I use the macro below that seems to work on other documents but not the one I need. I would appreciate any help.

Please Login or Register  to view this content.

[Alf]

As far as I can see and test this macro works ok. So perhaps one of the sheet names is not allowed as file names?

◾< (less than)
◾> (greater than)
◾: (colon)
◾" (double quote)
◾/ (forward slash)
◾\ (backslash)
◾| (vertical bar or pipe)
◾? (question mark)
◾* (asterisk)

These are windows forbidden characters in file names. Do you have any of these in your sheet names?

Alf

[Ninzzii]

Thanks, Alf. I have figured it out in the end, it's because one worksheet was password protected.

[Alf]

Thanks for feedback. Good to know

Alf