experienced

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?

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...

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...

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...

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...

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...

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...

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...

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...