How can I have my code check if the clipboard is empty so this code won't error out in that case?
My current code:
Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Sheet12.Range("C12:J12").Value = Sheet44.Range("A1:H1").Value
Application.ScreenUpdating = True
Someone already suggested trying:
If Application.CutCopyMode > 0 Then
but it prevents the code from doing anything even if there is something on the clipboard.