/code

  1. C

    Vlookup

    Hi, I am trying to execute following code, this code matches first 10 characters of two columns and if it matches then it copy and paste it in the workbook. /code .Formula = "=VLookup(LEFT(A2,5),'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A: /code it is...
    • Cloud67
    • Thread
    • .formula /code code matches woo[dump_parts_iwoo
    • Replies: 6
    • Forum: Excel Questions
  2. N

    Dynamic Range VBA Index Multi Match

    Hello, I have the following line that works fine but would like to have dynamic range for the array and lookup values. Cells(C,32).value = "=INDEX(RateSheet!C2:I5,MATCH(C2,RateSheet!A2:A5,1),MATCH(AE2,RateSheet!C1:I1,1))" C2:I5 and A2:A5 could have additional rows C1:I1 could have additional...
  3. A

    VBA code for Mail merge with To, CC, Subject, Attachments, Message Body.

    Hello Everyone, Somebody please help me out to get VBA code for automatic Mail merge with To, CC, Subject, Attachments, Message Body as <tbody> TO CC Subject Message Body Attachments path </tbody> Since I am very new to Visual Basic, I could not manage to write all codes. I want to...
  4. V

    ClearAll reset checkboxes

    Good Morning, I need some serious help programming a “Clear All” command button in an Access 2007 form. I have tried several codes found online without success. I have conceded to the fact that I’m lacking basic Access programming skills. Please help. <?xml:namespace prefix = o ns =...

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