Compile error in sub or function

[Paul1992]

This macro below works fine without any problems:

Please Login or Register  to view this content.

But the one below has a compile error for sub or function is there anyone that can enlighten me on the situation:

Please Login or Register  to view this content.

The bold highlighted is where the problem lies. I wish to move the items into a new Worksheet

Thanks in advance

[ChuckYeager]

Hi Paul,

Would need to look at the ExtracttoNewSheet code, as both codes seem to have a difference in the way they format the sheet before calling this function.

Regards

Chuck