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

VBA number formatting?

I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have... more

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.