VBA that exits a MACRO if clipboard is empty

[hans302]

Hi I have some code that relies on there being data in the CLIPBOARD prior to it being pasted, and I need some code instered into the VBA below that exits out of the macro when the Clipboard is empty or on an error or such like - Is that possible?

Please Login or Register  to view this content.

Of course I get a debug error on the PASTESPECIAL line if there is no data in the clipboard.

Can anyone help?

Regards
Hans

[davesexcel]

Hello,
Would it be better to copy the cell in your code, then you wouldn't have to worry about it?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[hans302]

I'm not copying cells

[davesexcel]

Your not copying cells?
But you are pasting cells...

[hans302]

I'm copying data from an intranet webpage into the sheet

[davesexcel]

Ah I see.

Probably:

Please Login or Register  to view this content.

should work, place it before the paste code