Hi all,

I have a complex macro which helps scrape websites and capture their data.

I run the macro over night, and unfortunately I keep getting a message box come up saying:

"Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
YES OR NO

I need a single line of code that can check the YES answer within the message box (then the macro resumes as normal)

Can anyone help? Anything would be very much appreciated!

I already have the IF ERROR RESUME NEXT function, which I thought was a 'catch all' but it clearly won't help with this one!

Many Thanks

Guy