Top "Vba" questions

Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications.

Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …

excel excel-2007 excel-formula excel-2010 vba
Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing …

excel vba ms-access
Writing a string to a cell in excel

I am trying to write a value to the "A1" cell, but am getting the following error: Application-defined or object-defined …

vba excel excel-2007
How can I send an HTTP POST request to a server from Excel using VBA?

What VBA code is required to perform an HTTP POST from an Excel spreadsheet?

excel vba http post serverxmlhttp
Fill formula down till last row in column

I'm trying to draw down the formula that's in cell M3 to the end of the data set. I'm using …

excel vba formula
How to use workbook.saveas with automatic Overwrite

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set …

excel vba excel-2010
Calling a Sub in VBA

This my simplified script: Sub SomeOtherSub(Stattyp As String) 'Daty and the other variables are defined here CatSubProduktAreakum(Stattyp, Daty + …

vba syntax-error call
Stopping Excel Macro executution when pressing Esc won't work

I'm running excel 2007 on XP. Is there a way to stop a macro from running during its execution other than …

vba excel terminate
Set background colour of cell to RGB value of data in cell

I have a column containing RGB values, e.g.: 127,187,199 67,22,94 In Excel, is there any way I can use this to …

excel vba rgb
VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds

I have a need to run a piece of code every 120 seconds. I am looking for an easy way to …

vba excel timer scheduling