bug

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

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

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

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.

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

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

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

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

Here's an irritating issue that has come up in the past few days. I have a spreadsheet with regular text and dates—no special formulas or formatting. When I double-click on a cell to edit the text directly, it leaves behind a strange border around the cell as well as a horizontal line above the...

I have an interesting question regarding VLOOKUP and ROUNDUP functions use together for numbers between 0.7 and 0.8. As you can see the attached image, numbers greater than 0.7 but less than 0.8 will not work with the ROUNDUP or TRUNC (you can ignore the outcomes for 0.6, 0.7 and 0.8 since this...

Using Excel 2010. I am attempting to display numbers as fractions in a message box. Sub HowToDisplayFractionsInMsgBox() Dim sngInput As Single sngInput = 0.75 'Selection.NumberFormat = "# ??/??" works to format a cell (and what VBA records) '="Fraction is: " &...

this problem is somewhat hard to describe so I made a video of what happens: problem with excel - YouTube as you watch the video notice that when I input something into a cell, excel will become disabled or grey and i have to click the cell again in order to keep inputting. i have had this...

Hello! I have a code that is essentially copy/pasting excel data to the body of an Outlook email. It works correctly 90% of the time, but I have had some users experience issues with ONLY the headers copying over to Outlook (no input data) and then the Excel spreadsheet data is cleared out. What...

Hey everyone, I am having a really strange problem with my excel file on something I feel like I've done many times before, but for some reason isn't work right now. I've got two sets of data, one for 2016 and one for 2015, in two separate tabs, that have the same exact headings in every...

I have a document with about 30 columns calculating based on a single cell value. This morning the formulas no longer calculates unless I add a trailing space. The reference cell is set with data validation to select from a list. I found that resetting the reference cell with the same value...

Sub DeleteSettleHKDDebitAccount() Dim checkrow As Long, lastrow As Long With Worksheets lastrow = Worksheets("借出-港幣").Cells(Rows.Count, "A").End(xlUp).Row For checkrow = 3 To lastrow If Worksheets("借出-港幣").Cells(checkrow, "F") <> "" Then...

Hey, I'm extremely new to the website and a true beginner at Excel. I'm studying Excel and its more complex formulas and my way of studying it is to take complex formulas and decompose them step by step to see how the results are formed. That said, I seem to be having some problem with...

Hi, i am trying to run this code but is stops at Sub statement (2nd line TT) i am new to VBA , is it related to the worksheet name? I have changed it but it still does not run. Option Explicit Sub LoanAmort2() 'This program is used to measure annual payment amount 'by using an iterative...

Hi, I am trying to run my code but it stops at one point and it says invalid procedure call or argument. Does anyone knows where is the problem? Thanks! 'Calculation of the annual payment annualPmnt = Pmt(intRate, loanLife, -initLoanAmnt, , 0) 'Initialize beginning balance of the 1st year...

Sub ShowStockWithRisingPotential() Dim sheet As Worksheet Dim CurrentRowNumber As String Dim RisingValue As Double, RisingThershold As Double, RisingTrend As Double, Result As Variant, i As Integer, j As Integer, Stock As Long CurrentRowNumber =...