Excel 97 Worksheet copy in vba problem...

[freds45]

Hi all

I wrote some vba code with Excel 2000 to copy a model worksheet to new ones, and it has to work with Excel 97...
Here is the code I used:

    Worksheets(modele).Copy After:=Worksheets(i)

It works great with Excel 2000, but in Excel 97, it always fails
I do not have vbaxl8.hlp to check the syntax, but it should be the same.

Can anyone help ?

 

[BrianB]

Nothing wrong with the syntax. Must be a problem with your variables not being valid. This is the general method :-

Workheets("Sheet1").Copy After:=Worksheets(1)

 

[freds45]

Well, I tried this, but it does not work neither
I can't see where the problem is!

What I have before is :

Const modele As String = "modele"

Anyone has an idea ? Is it because I designed it first with Excel 2000 ?

 

[freds45]

help