In this example, I have two columns of data: Date and Quantity. Example: (See Screenshot Link) What I'd like to be able to do, with an excel formula (if possibl
I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get
I have a workbook - lets call it Book1 Book1 contains 5 worksheets; Sheet1, Sheet1A, Sheet2, Sheet2A, Summary Within the Summary worksheet there is a table whic
I'm trying count number of values from another sheet into column O which has same system name as column B and more than Zero. Could you please let me know the b
Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home
I have a workbook that is about 8mb with about 20 different API calls (via formula in cells) using a 3rd party service. Everytime I try to close the workbook,
I have a spreadsheet that many people need to access (on sharepoint), for a few reasons, we need to do this locally (synced). however, there are constantly prob
I am trying to embed Python into an an XLL to allow Python functions to be called within Excel. An XLL is a DLL that also includes at a minimum 2 functions that
I want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first argument is range and second is criteria
I currently have the following code, which was made by a lovely member here Sub YearsNumberReduction() Dim LastCol As Long Dim DelCnt As Integer DelCnt = Sheet
I've been learning all the nifty tools I have to debug in the VBA editor for excel, but I can't figure out if there's a way to have watches st
I have a macro that can send multiple mails with attachments to an specific user, this had no problem when I sent 1 file to 1 user, but I modified it so it loop
Using an Excel formula, I'm trying to pull the MAX value for a NAME that has a certain LETTER next to it. Eg: Highest # for a specific % for each unique Name
I used code from the following article https://docs.microsoft.com/en-us/office/vba/api/excel.range.copy to partially accomplish my goal but I have a few more qu
I have an xml file which I am trying to import into excel but the most important column being imported has 18 digits and excel only allows up to 15 digits. I
i am trying to send emails through excel and keep the email signature i am able to either save .body as text withough the image or insert the image through .HTM
I added a UserForm into my file so comments can be added to a cell (that way I can update the data on other cells when a comment is added and someone is mention
I am using this code to convert rows to individual text files. Sub SaveWorksheet() Dim MyWorkbook As Workbook Dim MyDataWorksheet As Worksheet Set MyWorkbook =
I get a Type Mismatch Error "13" with the below code. Can anyone assist with where I'm going wrong with my VBA syntax and use of variables. If Applicat
I have a macro that intermittently throws a run-time error when doing a PasteSpecial. Most times it runs through to completion without failing, but sometimes i