vba; excel

  1. U

    VBA - Copy Each Columns Data in Row

    Hi Guys, I have this data below but what i need is to produce the data in list form Before: <tbody> ID RANK NAME NOTE1 NOTE2 1/30/2018 8/30/2017 5/30/2017 4/30/2017 1/30/2017 01 1 Ben 500 450 300 250 200 02 2 Sam 450 425 275 225 175 03 3 Max 425 400 250 0 0...
  2. M

    Need Help with VBA for Creating Emails

    I am trying to create a macro that will loop through a named range that contains email addresses to create an email with hard coded subject and opening line of the body. I then need to insert a range of cells based on a named range into the body and then send the email. I have been able to get...
  3. J

    vlookup formula in vba marco

    I want to make a macro based on vlookup formula from excel sheet. this formula is looking at k columns and go DataD sheet to get a value. =VLOOKUP(K6,'DataD'!D:G,4,0) I have something like this but it does not work... DataD.Range("D:G,4,0") = Vlookup() does anyone have solution for this?
    • jaik22
    • Thread
    • macro; columns; compare vba; excel vlookup; match
    • Replies: 1
    • Forum: Excel Questions
  4. K

    Slowing Down a Macro

    I would have never thought I would ask this in my entire time while using macros, but I just cannot figure out the issue and I need to use this macro before I can try to debug it. In the meantime, I just need it to s...l...o...w........d....o....w....n..... if you get that hint. Here's the...

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