• MVP Logo
  • Recent Forum Posts


    Excel Refresh All Stopped Working

    Sometime in the last week or so, the Data / Refresh All action stopped working in Excel on one of my Windows machines. I click Data / Refresh All (or...

    glennm0270 Today, 06:56 PM Go to last post

    Keeping excel formating in email body

    The email created does not keep the formatting from Excel.
    I know you can add HTML code to keep the formatting in the email body.


    Madjry Today, 04:25 PM Go to last post

    extract data from web

    The form is a POST form, not a GET one.
    Your request should be like this:

    With oXMLH        
        .Open "POST",

    ArdusPetus Today, 03:41 PM Go to last post

    Pivot table

    Your source data is already pivoted. Rearranging it into Month and Values columns will give you what you're looking for....

    NormS 2020-04-04, 11:01 PM Go to last post

    If , vlookup and drop down list

    Is this what you are trying to do? I've used INDEX/MATCH to do the equivalent of a VLOOKUP, along with INDIRECT to select the correct column in the price...

    NormS 2020-04-04, 07:04 PM Go to last post