View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_4_] Darren Hill[_4_] is offline
external usenet poster
 
Posts: 17
Default Worksheet Copy fails (xl2003)

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