troubleshooting

So I wrote a couple of simple macros that are used for formatting worksheets and changing cases of text. I want to make this an add-in that I can give to others to use. I have a key command set for one of the macros, and they all have buttons on the toolbar to execute them. When I create the...

I am working on a troubleshooting guide for powdercoat applications for work. I have a macro setup that brings up an input box upon opening the file, and it seaches a "tags" column for what the user inputs and returns what the potential problem and solutions are to those problems. the issue...

Hello, I am trying to use the following formula: =IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, ""))))) It works except for those values that fall in between two numbers, in this...

Dear all, I am a consultant and expert Excel user but have come across a problem I have not been able to solve. PROBLEM I have built a financial model, .xlsm, using Excel 2010 and Win7. Originally the file was 1.6MB and was working extremely smoothly. My client attempted to make some...

Good Afternoon, In my workbook I have a series of workbook_change events that, until the other day worked beautifully!! Now, the don't seem to be triggered when they should be. I have looked through all my code and removed all instances of Application.EnableEvents = False that could...

We have been using a pair of shared Excel workbook to manage a production schedule for many years, and have had very few problems. Recently I noticed that we were running in compatibility format, and since everyone was using Excel 2007 I saved the workbooks in .xlsx format over the weekend when...

I have a file with a worksheet that doesn't accept formulas even that begin with an equal sign and have accurate syntax. Rather than return a value, the cell contains the formula syntax with the equal sign. This problem can be isolated to 1 worksheet in the file. Any ideas what causes this...

Hi There, Im trying to do a mail merge from an excell sheet, when i pull the date in, i have a colum called "number" and it is the apartment number. the ones that are alph numeric, are coming up as 0 rof instance, if i have Apartment A-3 when the field displays in the mail merge, it shows up...

I am trying to create a spreadsheet for monthly expenses where the fixed expenses are on sheet 1 and the actual table is on sheet 2... Fixed expenses in sheet 2 are denoted by =Sheet1!$B$3 ect, referring to sheet 1. I then tried to sum up all of the months expenses I get the correct answer on...