7 Answered Questions for the topic vba
Running VBA Macro in AutoCAD?
I'm making a .bundle folder for the plugins I've programmed for AutoCAD. At the root of the folder is my PackageContents.xml bundle where all of my Lisp plugins are autoloaded. Since .dvb is not a... more
Copy Excel worksheet and maintain relative cell reference in formulas?
Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes... more
Deleting Two Columns Simultaneously?
The following code deletes Column J only: If Application.WorksheetFunction.Sum(Range("J:J").SpecialCells(xlCellTypeVisible)) _ =... more
VBA If <any of these> = <value>?
I'm fairly new to VBA, and I can't find an easy way to test if any of the specified variables equal a specified value. The below seems to work, but is there an easier way to do it? If variable1 =... more
Excel VBA Code to pull SSRS data as a dataset?
I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my... more
Click a button and the button would be unable to be clicked until reset?
Is there a way I could be able to click a Button and then once the button has been clicked it would be Unable to be clicked until the Form reset itself. Say... Enabling Auto-Save and can't be... more