• MVP Logo
  • Recent Forum Posts

    Bob Phillips

    Else if error in VBA

    Sub ifs()
        With Worksheets("Control")
            If .Range("O38").Value = .Range("O32").Value

    Bob Phillips Today, 08:13 PM Go to last post
    Bob Phillips

    Pivot table

    You need to update the data. You could also make a dynamic named range and set the pivot table to look at that....

    Bob Phillips Today, 07:52 PM Go to last post

    Pivot table

    If the original data has changed, how do you update the data or do you need to make a new table ?...

    vyhana Today, 06:37 PM Go to last post

    Confusion over averages in pivot table


    I'm trying to figure out why my pivot table is calculating a different average than when I do it manually.

    In the attached...

    Leanne Today, 11:51 AM Go to last post

    Else if error in VBA

    Hello! I'm a total beginner at VBA and tried to do the nested if function but after typing ElseIf, there's a msg box saying
    "Compiled Error:...

    whywhy Today, 09:42 AM Go to last post