# Questions tagged [vba]

Visual Basic for Applications; a subset of Visual Basic used in all Microsoft Office applications. Consider using this tag together with the tag for the specific application in question. Good questions on VBA generally contain some code and asks for solution of specific issues. Questions asking for entire solutions (please give me the code / how to do this and this with VBA) are off topic and will be closed as too broad.

**19**

**2**answers

### How do I add VBA in MS Office?

**10**

**5**answers

### How to combine values from multiple rows into a single row in Excel?

**5**

**2**answers

### How do I use Excel 2010 Personal Macro Workbook?

**2**

**3**answers

### How do I transpose data in columns to rows?

**7**

**1**answer

### How to replace text in the body of an incoming message with a hyperlink in Outlook 2010?

**4**

**1**answer

### Excel: Dual graded color scales

**6**

**1**answer

### Inserting a (jpg) picture into a cell in Microsoft Excel 2007

**5**

**1**answer

### Find and replace multiple values within selected cells

**2**

**1**answer

### Excel VBA code Private Sub Worksheet Change Power function not working

**4**

**3**answers

### Calculating the average of variably sized blocks of numbers within a column?

**1**

**3**answers

### Strange residue on cell with Data Validation when using Excel VBA

**14**

**1**answer

### Recover sheet protection password in Excel

**2**

**1**answer

### Execute SQL Query with VBA and fill sheet with data

**1**

**1**answer

### Create timestamp formula for Excel

**1**

**1**answer

### How do you prevent corruption of shared Excel files?

**2**

**4**answers

### Filling cells with sequential numbers in an Excel (2003) macro

**1**

**1**answer

### Sorting cells in a column is easy. But how to sort cells in a row?

**0**

**1**answer

### How to combine values from multiple rows into a single row using module?

**15**

**2**answers

### Any Excel function that will reverse a string?

**5**

**2**answers

### how to remove or change background fills in all tables in a microsoft word document

**7**

**8**answers

### Excel VBA “Unselect” wanted

**6**

**3**answers

### How to add custom styles to navigation pane or change them with VBA

**5**

**3**answers

### Extract data from delinked Excel plot

**2**

**2**answers

### How can I compare two columns in Excel to highlight words that don't match?

**2**

**3**answers

### VBA code to hide or unhide rows based on a cell value

**1**

**1**answer

### When using multiple accounts, how to ensure emails are sent from the correct account

**1**

**1**answer

### Filtering by currency in Excel

**4**

**6**answers

### Excel ran out of resources while attempting to calculate one or more formulas

**3**

**1**answer

### Excel Large Function with Duplicates

**3**

**1**answer

### Converting All Plain Text Links to Hyperlinks

**2**

**1**answer

### Copying data from multiple word docs into one excel sheet

**2**

**2**answers

### VBA Excel 2007 help to speed up code to hide rows [closed]

**1**

**2**answers

### Transform multiple columns in Excel table into multiple rows

**1**

**1**answer

### How to create multiple rows combining data sets

**0**

**1**answer

### excel vba: copy rows if data match with values in column in another sheet

**0**

**2**answers

### Microsoft Excel Macro for seperate rows to four different columns [closed]

**0**

**1**answer

### Clever way to connect multiple images to on-click macro - VAB Excel

**0**

**4**answers

### How can I tell if sheet a exists in a workbook?

**0**

**0**answers

### Worksheet_Change to Worksheet_Calculate

**-2**

**2**answers

### Excel VBA code to turn a row with a variable number of columns into fixed-length rows

**27**

**9**answers

### How can I use custom colours in the Microsoft VBA editor?

**35**

**17**answers

### Copy Excel worksheet and maintain relative cell reference in formulas

**6**

**3**answers

### How can I find out which parts of an Excel workbook are the biggest in size?

**4**

**2**answers

### VBA Syntactic Sugar

**2**

**1**answer

### How do you unprotect the VBA macros for a macro-enabled workbook if you forgot the password?

**10**

**6**answers

### Adding an element to the end of an array

**6**

**2**answers

### What would an Outlook 2007 macro to automate Paste Special - Unformatted Text look like?

**5**

**3**answers

### Trigger macro with ONE click on specific cell

**4**

**1**answer

### Show Excel column filter information in cells

**4**

**1**answer