Dynamically inserting a worksheet using After:=

[Loonytoons]

Hi guys,

I'm having trouble getting a worksheet to copy after the sheet I want.

Please Login or Register  to view this content.

I have a number of worksheets (currently numbered 1 to 10) as well as some others called various different things - the important thing is that the worksheet named 1 is not the first sheet in the workbook (and I don't want to hard code it as it may change).

My problem is that when I create a worksheet called 4, it is being inserted after the 3rd worksheet, not the worksheet called 3.

Hope that makes a bit of sense!!

I think it's this line that is the problem:

Please Login or Register  to view this content.

Ideally I would like to use the codename property but I can't seem to make that work.

Thanks in advance
Sandra

[Norie]

Sandra

Are you using numbers, eg 1,2,3 etc, to name the sheets?

If you are that could be causing a conflict btween sheet index and sheet name.

For example in code if you had Sheets(3) it would refer to the sheet with index 3, not necessarily the sheet with the name '3'.

To ensure you are referring to the sheet with the name 3 use CStr.

Please Login or Register  to view this content.

[Loonytoons]

Thanks Norie - that was it!