![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Mar 2002
Posts: 364
|
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 |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Hellas
Posts: 553
|
Hello Noir
I used your formula in excel2000 and i didn't get any error messages I did copy and paste too Regards Andreas |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|