Command Button Paste Function

[Guest_imported]

I have created a paste macro in excel, but want to disable it when there is nothing to copy, otherwise it keeps asking me to debug.

Can you help?

 

[xlbo]

Firstly - if it is a generic paste, why have you created a paste macro ???
there is a paste button and a shortcut (Ctrl + V) already assigned

If it is specific, add this to the start of your code

If application.cutcopymode = false then
msgbox "Nothing To Paste"
Else
paste code goes here
End If

HTH
~Geoff~

 

[ratman]

Consider this:

If Not IsEmpty(Selection.Value) Then