ActiveSheet.paste Link:=True

[Porkerjoe]

Hello,

I have a macro set up so when a command button is selected it will past whatever is on clipboard. My problem is if nothing is on clipboard and command button is selected I get the DEBUG errror.
Can anyone tell me what code I could put in there so If nothing is on clipboard and button is selected the DEBUG error won't appear?

Thanks,
Mike


Range ("C6").Select
ActiveSheet.paste Link:=True

 

[Von Pookie]

Try

Range("C6").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0

 

[Porkerjoe]

Awesome! It worked...

Thanks,
Kristy