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.

learn more… | top users | synonyms

11
votes
2answers
4k views

How do I add VBA in MS Office?

I've seen posts showing answers which use VBA (Visual Basic for Applications) code/macros, however, I've also noted additional comments afterwards about how to use the VBA (how to implement and ...
5
votes
2answers
16k views

How do I use Excel 2010 Personal Macro Workbook?

I want all of the macros that I've written to always be available when I'm using Microsoft Excel 2010. How can I do this?
2
votes
3answers
7k views

How do I transpose data in columns to rows?

How do I transpose data in columns to rows? If the data is: Joe some city some state Bob no city no state and I use Paste Special » Transpose, I get Joe some city some state Bob ...
8
votes
5answers
99k views

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

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: ...
5
votes
1answer
51k views

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

Is it possible to insert a jpg image inside a cell, or do Excel cells only display alphanumeric characters (or references)?
5
votes
1answer
27k views

Find and replace multiple values within selected cells

I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original word; B with the translation. I already found the VBA code to get this ...
2
votes
1answer
544 views

Excel VBA code Private Sub Worksheet Change Power function not working

I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is ...
4
votes
3answers
3k views

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

In column A I have a set of numbers (over 1,000), and I want to get an average of a block of them at a time, (e.g., 10, so A1:A10 then A11:A20 and so on) and write these averages into column B, such ...
4
votes
1answer
890 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
0
votes
2answers
108 views

Strange residue on cell with Data Validation when using Excel VBA

Thanks to Raystafarian I get rid of that left over Data Validation residue box by deleting all of them from the work book before exiting. Private Sub Workbook_BeforeClose(Cancel As Boolean) ...
4
votes
1answer
8k views

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

Does anyone know of a way or a program that will read a received email and recognize a static format of text (in my case it will be "#" followed by 6 integers), and make that a hyperlink to a webpage? ...
12
votes
3answers
52k views

Any Excel function that will reverse a string?

Are there any built-in Excel functions that will reverse a string?
2
votes
1answer
42k views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
2
votes
2answers
56k views

Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
1
vote
1answer
2k views

Create timestamp formula for Excel

The idea is simple, I'd like a function I could do something like =MOD_DATE_OF(A1:A4) and when any of the cells in such range is modified, the cell I assigned that formula gets the current date. I ...
0
votes
1answer
372 views

How do you prevent corruption of shared Excel files?

I have 10 or so Shared Macro Enabled Excel files that about 30-50 users modify multiple times each day. Over time the files get bogged down and bloated from excel thinking users are still using them ...
3
votes
2answers
10k views

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

I have a Word2010 document that was created by a tool from Axure. Each heading is formated with a custom style ("AxureHeading1", "AxureHeading2", "AxureHeading3"). I was able to create a table of ...
2
votes
4answers
23k views

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

I need to fill an excel column with a sequential series, in this case from -500 to 1000. I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single ...
1
vote
1answer
326 views

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

Assume school language learning exercise, based on making right order of words in a scrambled sentence. Then put numbers into the next row, specifying the order the words should be in. Now select ...
0
votes
1answer
11k views

Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count": Now the "Main" sheet has the column B with list of IDs. Is it possible to have a macro on "Count" page to copy all ...
12
votes
1answer
28k views

Recover sheet protection password in Excel

I have an Excel workbook. Two years before I set password protection option for one of the sheets. Now I have forgotten the password. Is there any way to recover the password of that Excel sheet?
4
votes
6answers
67k views

Excel VBA “Unselect” wanted

I would like the final appearance after my VBA has finished running to be empty of selection -- to have no cell or range on any sheet colored (if it was range selected) or in a bold line box (anything ...
4
votes
2answers
865 views

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

I have a bunch of large documents, with many tables that have different and inconsistent fill styles - some of them are not readable in black and white when printed. I cannot change the background ...
4
votes
3answers
8k views

Extract data from delinked Excel plot

I have a Word file which has some Excel plots in it. Unfortunately I lost the original excel plots and the word file is now 'de-linked'. Is there a way to retrieve the lost data for the plots? Just ...
2
votes
2answers
5k views

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

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
1
vote
1answer
504 views

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

I use 2 email accounts with Outlook. One for work, one for personal. The problem I have is I am forever sending work emails from my personal account! How do I set up a list of "do not send email to ...
3
votes
4answers
32k views

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

I received the error message "Excel ran out of resources while attempting to calculate one or more formulas" on ONE of my computers (Out of 2). My worksheet contains: (Inside a single worksheet, not ...
3
votes
1answer
1k views

Excel Large Function with Duplicates

I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...
2
votes
4answers
15k views

Excel runtime error “32809” corrupt workbooks?

Currently facing an incomprehensible issue with Excel... We have developed a work order electronic package that is used by about one hundred users every day. It is essentially the exact same workbook ...
2
votes
2answers
5k views

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

I am trying to write a VBA code that automatically hides rows if a value in the row is equal to "". My range of values is A37:A400. Because my range is so big my previous VbA is to slow and looks one ...
1
vote
2answers
2k views

Outlook VBA macro to forward email attachment, but delete message body

I am trying to add a custom action to a rule in Outlook where a message is automatically forwarded and the attachment stays but the original body message is deleted. I need to write code for the '...
1
vote
2answers
120 views

Transform multiple columns in Excel table into multiple rows

I have an excel table in the following format. ID Date1 Date2 Date3 1 1/1 1/2 1/3 2 1/2 1/3 1/1 3 1/3 1/2 1/4 Is there a way to change it into this format? ID Date 1 1/1 1 1/2 1 ...
1
vote
1answer
365 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
0
votes
1answer
2k views

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

I'm looking to combine multiple rows into a single row based on a value in the code column.. I've noticed other questions on here similiar to my question but I cannot seem to extend the range.. Code ...
0
votes
1answer
1k views

Macro problems excel 2010

Well i feel like pulling my hair out! i have a macro set up which splits my spread sheet into worksheets dependent on the data in column 6. I then have another macro which saves each of these as a ...
0
votes
1answer
275 views

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

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more. I am making a program in VBA Excel - or better, combining a certain worksheet ...
0
votes
4answers
65 views

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

I have the following code that's not working as expected: If Sheets("a") <> "" Then MsgBox ("sheet a exists") How can I tell if sheet a exists in the workbook?
-3
votes
2answers
86 views

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

I would like to change this: Filer ShareName IPAddress1 IPpaddres2 IPAddress2 ... ... .... ServerA /share1/tools 192.168.1.52 192.168.1.65 192.168.1.158 ServerA /share/library ...
4
votes
2answers
205 views

VBA Syntactic Sugar

I use VBA in my work every day, but I didn't know about Range syntactic sugar. I just knew last month when I saw MSDN Range page. I tried to find an article with this features, but I didn’t find any. ...
6
votes
2answers
6k views

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

I'd like to assign a macro in Outlook 2007 to a Toolbar button that would execute the equivalent of these clicks when there is formatted text in the Windows clipboard: Click the Paste icon by the ...
1
vote
1answer
875 views

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

I have heard myths about how easy it is to crack a VBA macro password, but haven't been able to figure out how to do it myself. We have an excel file at work where the VBA is password protected and ...
1
vote
1answer
18k views

Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive. I have an Excel workbook which contains around 50 columns I have a criteria column for splitting this workbook into mulitple workbooks The approach is as ...
20
votes
1answer
85k views

In Excel 2013, where are Visual Basic (VBA), Macros and AddIn tools?

In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
3
votes
1answer
12k views

Show Excel column filter information in cells

We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual ...
3
votes
2answers
8k views

How to avoid references in VBA (Early Binding vs. Late Binding)

I found a VBA macro that prints Outlook attachments automatically. A rule triggers the macro. But the macro needs a reference to Microsoft Scripting Runtime to work. I saved the code in ...
2
votes
1answer
1k views

Macro to merge cells in a column if the same rows are merged in a different column

I need help finding a macro that can merge cells across rows in a column if those same rows are already merged in another column. Below is a screenshot of what I have now that shows the cells that ...
2
votes
2answers
6k views

Excel - Create text file named after a cell containing other cell data

I'm looking to create a .txt file for each value in column A containing the corresponding values in columns B and C
2
votes
5answers
5k views

Outlook: apply rules to current message?

KMail has a really useful feature: you can define a series of rules which are only run when you press a keyboard shortcut, and then only on the highlighted messages. This allows me to read a message ...
2
votes
4answers
10k views

Basics of how to make a VBA procedure run in excel when a Cell is changed

I am trying show some data from my SQL Server in excel. Because I have a query that hits 3 tables and uses a parameter, I am going to have to use VBA. I am not sure how to get the VBA to "auto run". ...
1
vote
3answers
5k views

How to input only unique values in a column in Excel 2007

I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...