We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I have some code in VBscript that creates an excel object and adds a workbook to it Dim oExcel, oWB Set oExcel = CreateObject("excel.application") Set oWB =
I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p
I am trying to simultaneously read from one sheet and print to another sheet, with additional format. I think my issue has to do with improperly referencing the
I am looking to send meeting invitations for each row in a worksheet. I am able to create an item that when displayed shows as an appointment, not a meeting re
I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I
I have an exported xlsx file from c# (through angular).The Properties name which I want to be the columns header change in excel!( the first letters are changed
I have a dataset in Excel which I have imported in SQL Server. Is there a way in which when I make any change in the Excel data set like add/remove/edit rows or
I need to replace or substitute the first instance of a single text character in an excel row. current: B01 TEST TEST TEST A W B 0 A expected result where first
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