Slight edit needed with code..

I have a code that currently works apart from where x is nothing....because for some reason it stills proceeds to attempt to paste x (which, I think, should only happen where If Not x Is Not Nothing)

Essentially if x is nothing I would like to proceed to the second part of the code (the bottom half) but without attempting to paste x to a new sheet- which should only happen when If Not x Is Not Nothing because otherwise it is pasting nothing and takes me to the debugger...

Apologies if I haven't explained that well...anyway here is the code:

Please Login or Register  to view this content.

maybe so

Please Login or Register  to view this content.

Brilliant thanks nilem, so simple in the end!