happening

I have a sheet listing specifications for about 250 ingredients with headers for ingredient name, Supplier, risk levle , etc plus a few formulas. If I want to insert a new column Excel gives me a warning that the operation is going to take a long time. Why is this happening. If I copt the same...

Hi all, I am using this code right here ActiveCell.FormulaR1C1 = "=IF(RC[-1]="",IF([-35]<>"",RC[-35],"Misc"),RC[-1]" Whenever I go to another line I get an error message that says "Expected:end of statement". I do not know why this keeps happening. It is probably something simple I am just...

This below formula is only returning the first IF Statements Value if True value and everything else is just 0. Does anyone know why this is happening...

When you open a spreadsheet the top is always shows the columns as A, B, C, D... and the rows are always number 1,2,3,4.. When I click in a column the "Letters" and changing to numbers. I have never seen Excel do this. What's is happening to my spreadsheet??? It happened right after I ran...

=HLOOKUP('Input'!$C$15,C2:L49,47,FALSE) I would like a simple explanation of the above formula and how it plays in a workbook I was recently provided with? I know the first part is taking the number in c15 of the Input sheet but its whats happening from there that confuses me. What's...

Hi, ill try and make some sense here... ok, If I write "13:00" in a cell and format as a number I get "0.541666666666667" If I write 07:00 in A1, "07:15" in B1 then use the handle and drag to the right.. the 13:00 in this series formatted as a number is now "0.541666666666666" (Note the last...

My colleague encountered a strange issue with a simple sum: <colgroup><col></colgroup><tbody> 22.05 -7.05 661.00 -232.00 -20.75 6.20 -427.85 -1.60 Sum: -3.41949E-14 </tbody> <colgroup><col></colgroup><tbody> </tbody> If you reorder any of these it fixes it to zero sum...

This is more of an annoyance than anything. I have a form which generates an email and then quits Excel. The macro to run the code is on a shape, linked to the code. If I am out of a cell and anywhere on the worksheet it is fine. But if I am "live" in a cell, ie. editing when the shape is...

I am certain this should be an easy fix however I am having a terrible time trying to figure out why my formula is not working as it should. The below formula worksif conditions are met, but not if they have not been met. For example each cellreferenced has a date for its value. I want my...

Hi I have an issue with MS Word 2016 where I have tables within a word document. What is happening is that when I open a word document that has tables inserted if I start to type anywhere in the document the top row of the table can lose its formatting so that the top row loses parts of the...

I can't edit formulas within the formula bar. Whenever I move my mouse cursor to the formula bar, there's a scroll bar that pops up. Here's a picture of it. This is happening with all files, not just a single particularly file. Does anyone know how to fix this? Attaching a picture...

Hello - I have a macro that was working just fine and suddenly not working and getting catastrophic error message. Any ideas what's happening?

When I highlight a range I want to copy and type Ctrl-C, the entire application freezes, and my mouse cursor becomes a spinner icon (i.e. indicating that Excel is thinking/processing), which prevents me from interacting with Excel at all...this usually lasts between 30 and 120 seconds before the...

Hi, I am a little confused by the following rounding tt = Round(1915.5 * 3.27, 2) 1915.5 * 3.27 = 6263.685 so the rounding should round up 5 to 6263.69 but I am getting 6263.68 What is happening? This is excel 2016 Thanks

Does anyone know why sometimes the macro name is preceded with the workbook name when I "F8"? And how can I get that to stop happening....

I am recording a simple macro: going from one spreadsheet to another. When I do, VBA records the step as ("Name of spreadsheet").ErrorString, when it should be, Sheets("Name of spreadsheet").Select Any idea why this is happening? Thank you so much!!

Hello everyone, I have been working on a Excel/Vba project for a few months, but recently, this issue cropped up. When my file is opened on other computers, Windows Installer runs (right after clicking 'enable macros'). This isn't a huge problem so far, but I'd like to understand what is...

Hi I have this code happening in Excel, would like to do it in Access but do not know how. Can someone help? =IFERROR(VLOOKUP($AG5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($M5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($N5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($AC5,VST!B$11:C$85,2,0)," No"))))

Hi All, When I try and click and drag to select cells to copy (for example) if I have to drag to make the page scroll down Excel keeps entering this weird formula and it is really difficult to get rid of - does anyone know why it is happening (or what stupid thing I am doing???) Pic of example...

Hello, I've attached an image below to show what is happening on my worksheet. About half the time, when I open my file, there seems to be a display bug. If the bug occurs, I can still select cells and enter information, but the green outline around the active cell disappears (I have the same...