Add worksheets,

[Hurricanefly]

Hi, I have written this code to add worksheets to workbooks. It works okay apart from it adds the sheets in reverse order I type 15 in the (Inputbox) and it adds 15 where worksheet 1 should be. Any ideas? Thanks

Please Login or Register  to view this content.

[JasperD]

you forgot to add "After:=Worksheets(Worksheets.Count)"

Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[Mumps1]

Try changing this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[JasperD]

isn't that what I said?

[Mumps1]

It certainly is. When I started writing my response, you hadn't yet posted yours.

[Hurricanefly]

Thanks guys, i'm not sure if its me but i'm still getting the sheets in reverse order?

[Mumps1]

Can you post a copy of your file?