experienced

  1. T

    VBA Worksheet_Chnage event bug

    My program has both a Worksheet_Change event and a Worksheet_SelectionChange event. For some reason, when it runs to the end of the Worksheet_Change event, it jumps to the Worksheet_SelectionChange event. Has anyone experienced this before?
  2. E

    Index Match with multiple results

    Hello all, I hope that someone more experienced than I in here can help me where I have gotten stuck :) I have the following workbook: In this work book, I have a list of sales in different categories, and I am trying to show a ranked list for a selected Category, what the Sales and the...
  3. C

    IF AND or IF OR - HELP

    I'm sure there is a more efficient way to write this formula. I'm hoping my Excel Brain Hive and help. I've attempted to break it up in lines. =if (AND(M3="Low",N3="Low",O3="Entry/Lower Level"),"No Change",(AND(M3="Low",N3="Medium",O3="Entry/Lower Level"),"No...
  4. E

    Simplified SUMIF

    Hi everyone - Happy Monday! Apologies in advance as this is a little convoluted. Wanted to see if anyone has advice on a formula I'm about to write in regards to a SUMIF. Basically, I am working with 4 quarters of result data (result in my vernacular means a dollar payout for context). Each...
  5. Jaafar Tribak

    Creating Menu Items In The VBA Editor -Code from chip pearson (excel 64 bit issue)

    I downloaded the workbook from Chip's site but I keep getting error 438 at the following line : Set MenuEvent.EvtHandler = Application.VBE.Events.CommandBarEvents(CmdBarItem) Has anybody experienced the same problem ? Is this a bug ? The code works on excel 32bit but errors out on excel 64bit...
  6. jim may

    What's going on with my system when...

    Working with the underlying Excel Post System recently, As a copy a given amount of text from outside the site and then I come into the Post New Thread Textbox and either 1) Control+V, right-click-select Paste NOTHING gets pasted in. What's the problem? Anyone experienced this before? Also...
  7. I

    Switch Row/Column Button in Data Group of Chart Tools Design Tab Greyed Out

    This is driving me crazy because I have instructions to do this, but no matter what i do to try and resolve it nothing is working. I've googled this issue and apparently others have had the same issue, but was never really able to get help. I know somebody from community will have experienced...
  8. M

    Excel 2016 64-bit Issues

    Since converting to Excel 64-bit version, 2016, I have experienced a few undocumented features. I don't know what has to do with what but if anyone has experienced and solved any of the following I'd really like to hear what you did: 1. The command: Application.ScreenUpdating = False seems...
  9. T

    Application.IgnoreRemoteRequest

    If this is set to false, ie Application.IgnoreRemoteRequests = False then if a workbook in an instance of Excel is already opened, any attempt to open another Excel file from Windows Explorer would open a new instance of Excel, then opens the file (tested on Excel 2013). However, my...

Watch MrExcel Video

This Week's Hot Topics

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
Top