Compile Error - V.Strange

Hi There, hoping someone can help me with a confusing issue I am experiencing with a macro.

I have written the below macro which is used across three reports. This particular macro has been used as my 'beta' version as a work in progress to get it to a stable point before implementing the same changes across the other two reports. I have got this report to a standard and stability now that I want to bring the others in line with it...

Please Login or Register  to view this content.

The above is working perfectly and is stable in day to day use, however when I implement the same save method:

Please Login or Register  to view this content.

Into the other report i get a compile error....

This is the report before I put in the If exists function

Please Login or Register  to view this content.

And it works as it should, however when I put this in as so...

Please Login or Register  to view this content.

I get the compile error...

Can anyone offer any advice as I have spent many frustrating hours now looking at every line... The compile error seems to have a problem with the sub name CreateNew() however it's confusing as it works fine before the if exists statement is in, the sub name does not change. it seems to stop at If exists, however it works fine in the other macro?

Hope I have explained this ok!

There is no Exists function in VBA. Have you written your own? If not, use:

Please Login or Register  to view this content.

instead.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Probably it's simpler to copy the activeworkbook.Sheets("MACRO CONTROLS"); it automatically creates a new workbook.
Formatting the sheet in the new workbook isn't necessary anymore. Probably you only have to remove data in it.

Please Login or Register  to view this content.

PS. Avoid using 'activate', 'select' in VBA.