Results 1 to 7 of 7

Thread: [RESOLVED] Corect runtime error in matching columns

Threaded View

  1. Aug 3rd, 2015, 08:30 AM #1
    elmnas
    elmnas is offline

    Thread Starter
    Lively Member elmnas's Avatar
    Join Date
    Jul 2009
    Posts
    127

    Resolved [RESOLVED] Corect runtime error in matching columns

    Hello guys I have got following code,

    the code check column A and B in sheet1 then match them with sheet2 A and B,


    Sheet1
    Name: XiPnDCY.jpg Views: 294 Size: 8.9 KB


    Sheet2
    Name: xP4x4FM.jpg Views: 319 Size: 7.4 KB

    if column A and B sheet1 match column a and B in sheet2,
    take the matching cell in this result,
    sheet 1 same row column J the value * the value in column G same row sheet2,

    but if there are cells in sheet1 and column A and B that not exists in Sheet2,

    I get this error

    Runtime error 13 : incompatible types




    See attached file.Compare_cells.zip

    Could someone help me ?

    Thank you in advance
    Last edited by elmnas; Aug 3rd, 2015 at 10:08 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width