My sheet was very hidden, too.

I can live with it now that I know about it.
Thanks again for your help.

Darren

On Sun, 01 Apr 2007 13:24:22 +0100, Dave Peterson
wrote:

I had trouble if I was copying any non-visible sheet to a new workbook..
But in
any workbook, one sheet has to be visible--so that makes sense to me.

I didn't have any trouble copying a sheet that was xlsheethidden (within
the
same workbook).

I had trouble with sheets that were xlsheetveryhidden (within the same
workbook).

I have no idea why there's a difference between the behaviors in the
last two.
From my standpoint, there just is <vbg.

Darren Hill wrote:

Thanks, Dave.
I tested, by having the code make the sheet visible, perform the copy,
then hide it again, and it works.
So, being hidden seems to stops the copy on some versions of the
workbook
and not others. Can you explain why this is?

Darren

On Sun, 01 Apr 2007 02:23:23 +0100, Dave Peterson
wrote:

Is the sheet hidden?

Darren Hill wrote:

I'm getting a very strange error.

This line generates an error:
Worksheets("VBA_BlankRecord").Copy
after:=Worksheets(Worksheets.Count)

as does this one:
Worksheets("VBA_BlankRecord").Copy

The error is runtime error 1004, "copy method of worksheet cllass
failed"
(I could figure that part out myself!).
In security, I have Tust Access to the Visual Basic Project checked.

Just to make sure I hadn't misspelled the name, I tried this line:
Set ws = Worksheets("VBA_BlankRecord")
and it works fine.

If I try an earlier version of the workbook, the lines above work,
even
though I haven't changed anything this procedure, or the worksheet
it's
copying, since that earlier version.

Darren


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/




--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/