Hi,

I'm trying to create a macro to insert a new tab and rename it to "Consolidation Assumptions".

However it keeps failing as the sheet thats being inserted may change its existing name, ie - it may be "sheet 9" then next time i run the macro it may be "sheet 10" depending on what i've done before.

Does any one know the code i should use?

Any help appreciated,

Thanks