bug

  1. GraH

    XL2BB bug?

    Hi, Let me start by saying the XL2BB add-on is awesome. I can't imagine what the coding behind must be like. I'm in awe. One thing starts to bugs me however. Each time I start up Excel the "Mr Excel" is gone from the ribbon, while the add-on is still "flagged" in the list as selected. The...
  2. S

    Using listobject name reference in chart series issues after update

    Hello! I've encountered very weird behavior of Excel after latest update (semi-annual channel). Everything was working perfectly for over a year now. I've created addin (VBA), that creates charts automatically from pulled SQL data. I used following format for series data definition: SERIES...
  3. E

    Data Validation Bug

    I have a worksheet that has thousands of cells containing data validation. I recently noticed that when I copy an entire row from the original worksheet to another worksheet (within the same workbook), the data validation in some of the cells change unexpectedly in the destination. The data...
  4. N

    Odd Regular Expression Issue

    Is this some kind of undocumented bug, or am I having brain gas?? Here is the string... myStr = "<comment id='234679' author='Bill McKale' created='Wed, 14 Jun 2019 11:56:44 -4000'>'This is not a viable solution. Please read SOP 48824.66A'<comment>" Here are 4 variations of the pattern...
  5. I

    Run Time Error 1004

    So I have two excel versions one at home and one at work. Both are excel 2016 but the one at work is blocked for updates. The bug I'm getting is on the most up-to-date version at home. Excel at work doesn't seem to have this bug. And here's the code: .Add Type:=xlValidateList...
  6. P

    Copy Paste macro not working

    Hi There I got this macro from Mr Excel forum but I forgot who gave it to me. I have a bug on the line that says: If MyData(r, 1).HasFormula = True Then The bug says "Object Required" Can someone fix this for me? Below is the macro Sub CopyPaste1() Application.ScreenUpdating = False Dim...
  7. S

    Calculate and populate duration (days) into cell 3 from cell 1 & 2 that contains specific words

    Hi All, Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread. This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved. What i'm trying to do is calculate and populate the SLA Deadline cell...
  8. pbornemeier

    Merged Cell Offset Inconsistencies

    I ran across a problem when I had to deal with merged cell offsets and thought I would share my results, Summary: Avoid offsets from merged cells unless you test all results. Some offset directions return the address that would be expected if the cell was not part of a range, others return a...
  9. dannyok90

    VBA bug in delete row code (with buttons)

    Hi all, Im having some intermitant trouble with the followin code (line where i've put the arrow) The code sometimes breaks here and i have to close the spreadsheet and reopen it.. it works fine after that.. until it does it again. Any ideas? :) Thanks, Dan Option Explicit Sub...
  10. R

    Can you replicate this simple Excel bug? Microsoft support can, but refuse to take action until more people complain

    The latest Excel release appears to have a very simple yet potentially critical bug with autofill. Values will lose or gain 0.0000000000001 or <del style="box-sizing: inherit; color: rgba(0, 0, 0, 0.6); border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing...
  11. G

    Macro for inserting pictures bug

    Hi guys, I have the following macro which works as follows: once run, it reads the product codes (e.g. 12381-1231) in column B and inserts corresponding product pictures from another folder to the excel file. Now the problem is that even when I save the document and then send it to others, they...
  12. H

    Active Cell Outline Bug

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

    Copy/Paste Error

    I have a simple spreadsheet, with no filters and no complex formulas. When a copy a cell in a given column (any cell and any column, even those with no formulas) and paste it, excel paste the value of immediate below cell (incorrectly). For exemple, if I copy cell B7 and paste it in cell B1...
  14. O

    Marco error deletes raw data, but only on the first run

    Hi! I have two files, one is a CSV raw data set and the other contains my macros. The macros modify the raw data set so that it is readable and adds some tools to the file that help analyze the data. The first time I run it chunks of data are deleted from the raw data set and outputs are...
  15. E

    Date issue in macro recording

    If there are two dates column and both the headers of date column is named as 'Date' . I have observed that when i extract the data through advance filter the date value of both column appears correctly i.e values of both column my differ . however when i apply the same working through macro the...
  16. Z

    Workaround for Excel Text Box Bug?

    I've recently discovered that Microsoft's in-browser Excel editor for SharePoint and Teams does not allow users to edit text boxes. 1) are there any work-arounds for this? Also how has microsoft not fixed this? I've found documentation from this going back to 2010.
  17. J

    CDO Message makes Excel unstable

    Did anyone ever have / solve the problem where Excel becomes unstable and "buggy" after you run a macro that uses CDO Message to send an email? I saw other posts but never a solution. My code worked fine under Win Vista and Excel versions so it's not an obvious bug in the code, but when I run...
  18. S

    Help working IF(COUNTIF round a bug

    Hi all. I have tried using formula =IF(COUNTIF(WorkingsOut!I4:I40,'Drop Down Data'!E3),'Drop Down Data'!H3,IF(COUNTIF(WorkingsOut!I4:I40,'Drop Down Data'!E4),'Drop Down Data'!H3,'Drop Down Data'!H2)) which links to a different workbook (Via a macro). However, I am led to believe there is a bug...
  19. S

    Amend email recipients in code

    I have the following Code that opens a UserForm that has 6 buttons that puts a certain project email list in the .cc line. The bug I am having is that when I actually delete and email in the email bar, the macro will remember it and put it back in the .cc line. For example I Have Email A B and...
  20. D

    Graphs not updating - Excel bug?

    So I have a sheet with multiple pie chart graphs on it with a vba code that pulls out of an SQL database. What I am running into and I feel like an actual bug in Microsoft excel. My VBA code changes the color of the pie charts based on a few different variables and the code is set to cycle every...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top