Cut and paste error message problem

Noir

Active Member
Joined
Mar 24, 2002
Messages
362
I use the following formula to match data between sheet1 and sheet2 of my workbook;
=A2&" Found in row "&MATCH(A2,Sheet2!$A$1:$A$1000,0). The formula works fine but,
when i cut data from a source workbook and paste it into my main workbook, i receive 2 separate error messages 1.Visual Basic Error="File Not Found". 2.MS Excel Error="Cannot Paste Data". Although the data does paste successfully, i get these error messages everytime.

Please advise as to how i can get rid of these error messages.

Thx,
Noir
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Hello Noir

I used your formula in excel2000 and
i didn't get any error messages
I did copy and paste too

Regards

Andreas
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top