How to make changes in a new workbook opened from an active workbook

[j_Southern]

Iam using the following code to save a range in the active workbook into a new workbook.

Please Login or Register  to view this content.

This works fine as long as the line EditSheet SheetName is excluded. If it is used then I get a message "subscript out of range" because of course there is no sheet called sheetname in the new workbook.
I am sure there must be a simple way out of this out of this corner, but I can't find it.
Can anyone help please.
John

[cytop]

Assuming EditSheet expects a worksheet object, it's not clear from the context...

Please Login or Register  to view this content.

But, on re-reading it, nothing is clear.

Which worksheet do you want to edit? What's the code for EditSheet. especially the declaration?

You really should not rely on ActiveWorkbook or ActiveSheet - there are times, probably like now, when it is not clear what the active workbook is.

For example:

Please Login or Register  to view this content.