End vba if nothing to paste

Hi I have the following code, but I don't want it to carry on after line 4 if there is nothing in the clipboard to paste instead I want it to come up with the following message and then end sub:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

many thanks

Without a sample workbook it's difficult to know if this is what you mean, but perhaps it will work...

Please Login or Register  to view this content.

BSB

You can also use the

Please Login or Register  to view this content.

line to end the sub from any line.

Originally Posted by maniacb

You can also use the

Please Login or Register  to view this content.

line to end the sub from any line.

Correct, however, I would consider this bad programming practice and to be avoided wherever possible.
A single exit point means code is easier to follow and less likely to cause headache further down the line.

BSB