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
|