Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Cut and paste error message problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Noir

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

    Regards

    Andreas

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •