bug

I have a complex worksheet/graph I'm building that requires a lot of array building. I've run into either a bug or a side-effect that prevents an array function from being evaluated properly when used in the following order of functions: IF ( condition, OFFSET( ref, ROW(A1:A4), col)) Normally...

I have a curious error that appeared in several places at once. Automation Error - Catastrophic Failure This all of a sudden started to appear when opening a workbook I had been developing. In practice I have saved this in a series of versions before advancing stage to stage. As I couldn't...

Hi guys, I have the strangest behavior in an Excel worksheet I have ever seen. I have uploaded a small portion of my worksheet to my dropbox. https://www.dropbox.com/s/ptm4ie27k3gl0pc/Strange.xlsx?dl=0 Strange behavior 1 The first formula calculates the age from a date of birth. Works fine, no...

I narrowed it don't to this: Function test(oRange) 'called by A1: =test(B1) test2 oRange 'this works Stop 'BUG: "test2 oRange" in the Immediate window while here in debugmode gives: "Run-time error '51': Internal error" End Function Function test2(ParamArray...

Hi, I thought I’d share this to get your thoughts. I have only 2010 – does anyone get the same with 2007, 2013, 2016, etc.? Steps to reproduce: 1. Create a new workbook with at least two tabs. 2. On one tab make a table (ListObject) with headers and data a. In cells A1:A2 enter a label...

Hi, First time on this forum so looking forward to improving my Excel skills here. I'm not an Excel newbie but I'm not an expert either. I've been building a tabular dataset using results posted on ResultsDB detailing English Premiership football results going back to season 2000-01. The...

Hy everyone I have got this weird bug, which I can't understand. With the following code in VBA I try to insert a formula: For Each Cell In Range("A28:A102") If Cell.Value <> "" Then Cell.Offset(0, 1).FormulaR1C1 = "=COUNTIF(Januar_Data!J:J,RC[-1])" End If...

Dear all, At our company we have a problem with several of our (very different) models. When running a macro (or inserting rows) other sheets are partially bleeding through, meaning you can see a part of another sheet that is not selected at that moment. See example below: -- removed inline...

So what I am trying to do is delete unwanted rows in one Sheet if they do not meet the validation values from 2nd sheet. I have a tag list with tags that are associated to a system. Some systems are not part of the project so I need to purge these from the excel list before I can run a status...

In using code to insert additional lines the height of the plotarea in a chart, I found that the lines sometimes were not the correct height. I found that when the window zoom was not at 100 the Chart.PlotArea.InsideHeight Value was not always correct. Further work showed that the InsideWidth...

hi, i have an unusual error with data validation drop-down list. when i creating drop-down list in excel 2010 - everything was fine - like it supposed to work. when i open the same workbook in excel 2013 - i get an graphic error. the cell don't show the scroll bar object and there is an black...

I'm creating a forecasting worksheet that pulls values from a separate sheet using an array. Starting out, the array was working fine. I was able to copy, paste, and drag it through the necessary cells easily; that is, until it suddenly stopped working. About halfway through my forecasting...

This code exposes what I consider to be a bug in Excel along with a workaround. It will probably not occur in most circumstances. Option Explicit Sub DemoProblemWhenUpdatingFormulasInNonAdjacentCells() 'This code demonstrates a problem that I found the hard way ' as well as a...

Has anyone else noticed that Excel 2013 64bit will not sort data if there are more than 524160 rows to be sorted? Nothing here suggests that this would be a limitation, Excel specifications and limits - Excel My friend who is running Excel 2010 64bit doesn't have this limitation. The only...

Hi, I use VBA in excel for months and suddenly got a problem a few days ago concerning the VBA excel menu and access to the code. I can still run my existing codes and use the function record macro. But a bug appears in Excel: I can’t inside the developer tab open the menu “Visual Basic” or...

I have a big Excel add-in that I've made using VBA. It has lots of different subroutines and functions. Part of it creates a set of charts, formats them and then positions them in a new worksheet so that they can be exported as a PDF. When I run this subroutine, the charts do not position...

My test case can be downloaded from http://home.comcast.net/~jasmith4/ExcelVBAroundBug/RoundBug.xls It's an Excel 2003 file, but the bug shows up in Excel 2007 and 2010 too. The bug has to do with VBA rounding numbers that end with one decimal digit, xxx.5 -- for example, if you round 0.5...

I ran into a little bug while running one of my macros this morning. After doing a bit of investigating I found that the problem was due to this line: Range("b2:b" & Range("a1048576").End(xlUp).Row).Replace what:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False The...

I have Office 2013, and have an Excel inspection form our technicians are going to be filling out in the field on tablets. There is a section for Notes that they can enter free text, and I've used an ActiveX text box for that purpose. But if I set the property "Multiline" to true, the font...

Excel 2007 <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead> A B </thead><tbody> 1 92458901135721576158003019 4 2 92458901135721576158001015 3 92458901135721576162001018 4 92458901135721576162002015 </tbody> Sheet1 <tbody> Worksheet Formulas <thead> Cell Formula...