Is there a way to test if there is data in the clip board?

[USAMax]

I have a routine that is dependent upon pasting data. The routine will exit on the error but I would like to skip the routine before it gets that far.

Is there a way to test if there is anything that has been copied?

I'm using Excel 2010 on a Windows 8 desktop.

 

[admiral100]

Maybe Ctrl +C+C

 

[JoeMo]

I have a routine that is dependent upon pasting data. The routine will exit on the error but I would like to skip the routine before it gets that far.

Is there a way to test if there is anything that has been copied?

I'm using Excel 2010 on a Windows 8 desktop.

Dim x as long
x = Application.CutCopyMode

x = 0 --> nothing on clip board
x = 1 --> clip board not empty

 

[USAMax]

I'm sorry Joe but it always comes back as Zero. I have one routine that is stripping data from a demographic website if it exists then, after it ends, I need to know if it collected the information before running the next routine.

 

[JoeMo]

I'm sorry Joe but it always comes back as Zero. I have one routine that is stripping data from a demographic website if it exists then, after it ends, I need to know if it collected the information before running the next routine.

That puts the data, if any, on the Office clip board, but doesn't put Excel's CotCopyMode into xlCopy mode. You can see the data on the Office clip board (Home>Clipboard), but I don't know how to access that programmatically.