VBA copy values to newly created sheet problem

[dusoo]

Hi guys,

I'm trying to copy content of one sheet to newly created sheet. The copy&paste code I created using "record macro" option.
Code below fails on the line "Sheets(wsName).Select" with error 400. (select method of class Range failed)
Could you please write what's wrong with that?

Thanks

Please Login or Register  to view this content.

[xladept]

Try:

Please Login or Register  to view this content.

[dusoo]

I get same error.
Is there another way to copy & paste?
I have tried this code below, but xlPasteColumnWidths does nothing, replacing it by xlPasteValues helps, but no format is copied over which is bad.
Any ideas?

Please Login or Register  to view this content.

[xladept]

Try this:

Please Login or Register  to view this content.

[dusoo]

Thanks, it worked. So I don't have to Select newly created sheet...

[xladept]

You're welcome! No, the newly created sheet is always the active sheet.

(Don't forget to mark this thread as solved.)