Feb 17, 2016 · I'm looking to improve the runtime and efficiency of my VBA code that performs multiple Replace operations on an Excel Spreadsheet. I started out with the following (please …

A user asks if the implication [excel] + [vba] => [excel-vba] is true, and gets answers from other users. The discussion also covers the purpose and usefulness of the excel-vba tag and the …

May 7, 2009 · I believe I'm running into an overflow stack with a fairly large MACRO program. Will chopping the VBA MACRO into call routines reduce the stack size of the MACRO?

Apr 3, 2020 · you should call a function and return. in this case you put the address at which the function was called onto the stack and this address is used (stack is cleared) for further …

Jan 15, 2008 · Does anyone have any insight into how stack limitations have changed in VBA in recent versions of Excel? I am trying to wrap my mind around the fact that it worked in year …

1 day ago · Excel's Macro dialog box only displays parameterless public procedures. When you add an argument (like ByRef wkb As Workbook), Excel doesn't list that macro because it …

Jun 27, 2018 · Splitting excel-vba into excel and vba means that anyone interested in excel will see the question, and anyone interested in vba (with any Office program) will see it. A rather …

1 day ago · Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your …

3 days ago · 其次，宏可能在Excel中被禁用。您可以通过转到Excel选项，选择“信任中心”，然后选择“信任中心设置”来检查这一点。 ... 有关宏或者宏文件的问题，如果问题依然存在，您还可以 …

Apr 8, 2019 · Disable events first using application.enableevents = false then set it back to true after the code that clears the cells. I don't ever recommend disabling events. There are much …

Mar 29, 2025 · Let's say you have some numbers in cells A1 to A5 of your Excel sheet, and you want to double the value of each of these cells using VBA. Here's how you could do it with a …

I have an Excel sheet that acts as a 'form' and uses VBA to walk users through the workflow. When the next persons input is needed, the user presses a 'Submit' button and VBA triggers …

Mar 5, 2015 · The error is non-specific, but I suspect that your worksheet might be lacking objects named PivotTable1 or it's missing a field called Impressions.

2 days ago · An alternative that can make your life much easier is to add a reference to the Excel object model. Use Tools->References and set a check on Microsoft Excel 16.0 Object Library. …

Sorting an Excel object in Visio using a macro (VBA) Currently trying to use the following function to sort some data in a Visio Excel OLE Object. I have confirmed that it can Select the Range …