# Tagged Questions

**-1**

votes

**1**answer

18 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**0**

votes

**0**answers

18 views

### Replace multiple words in Excel sheet

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**1**

vote

**1**answer

52 views

### Find and replace multiple words in a column in Excel 2007

Sub xLator2()
Dim s1 As Worksheet, s2 As Worksheet
Dim N As Long, i As Long
Dim from(), too()
Set s1 = Sheets("Sheet1") ' contains the data
Set s2 = Sheets("Sheet2") ' contains the translation ...

**2**

votes

**1**answer

41 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**2**

votes

**0**answers

46 views

### copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer.
I'm fresh to vba, but I thought I can handle it. I was wrong. I ...

**0**

votes

**0**answers

34 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

27 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**0**

votes

**1**answer

58 views

### How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...

**3**

votes

**1**answer

166 views

### Add/Subtract button Excel VBA

Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...

**1**

vote

**1**answer

62 views

### Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values.
However, experimentation suggests that the data validation drop-down list will never display at a smaller ...

**1**

vote

**1**answer

24 views

### How to generate a series of growing values and timestamps for cell that updates automatically?

I have a cell A1 which references a sheet that gets updated by an external source (database). My goal is to record a log that traces the growing value of cell A1 at each different time the data is ...

**0**

votes

**1**answer

76 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**0**

votes

**1**answer

40 views

### New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document.
Everything ...

**0**

votes

**1**answer

519 views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**0**

votes

**1**answer

110 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**0**

votes

**1**answer

1k views

### VBA Excel: Function to find a string in another workbook

I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the ...

**0**

votes

**1**answer

214 views

### VBA Excel: How to select only numeric values in a range?

I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column.
I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...

**0**

votes

**1**answer

343 views

### Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...

**0**

votes

**1**answer

165 views

### VBA string search within files in directory not working in Excel 2007

I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...

**0**

votes

**0**answers

80 views

### I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

Please excuse me if I'm posting incorrectly in any way- this is my first go round on superuser.
I'm looking to create a fairly basic VBA macro to automate a process in excel I'll otherwise have to ...

**0**

votes

**0**answers

108 views

### how to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have:
![Input File][1]
Product Currency Value US UK Japan Ind ...

**0**

votes

**3**answers

75 views

### Combine rows in Excel

I have data in column 1 and data in column 2 as follows:
1234 eggs
1234 bacon
1234 toast
4321 Orange Juice
I want it to appear as follows:
1234 eggs-bacon-toast
4321 ...

**1**

vote

**1**answer

106 views

### Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...

**0**

votes

**0**answers

283 views

### Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...

**1**

vote

**1**answer

126 views

### How to access the formatted text within an Excel cell with VBA

I have embedded formatting within an excel column. For example, a cell might contain some (but not all) italicised words.
The .Value, .Value2 and .Text properties seem to strip any formattting.
I ...

**0**

votes

**0**answers

42 views

### VBA Editor on F8 shows outlook insted of Step Into

Excel VBA Editor on F8 shows Outlook insted of Step Into. I don`t use it and it wants me to add my e-mail configuration every time. In other applications F8 works properly. What am I doing wrong?
...

**0**

votes

**0**answers

43 views

### Excel Macro looping

I used this macro and it worked fine, but I needed a little bit more.
I had to change LookAt:=xlWhole to LookAt:=xlPart and add the color formatting. Now, when I select a column, the Macro appears ...

**0**

votes

**0**answers

43 views

### Excel: Automatic data transfer when excel workbook updated

I'm wanting excel 2007 to automatically identify and transfer the new rows of data from one teams spreadsheet to our own.
Is this possible within excel? I envisage a macro would be able to compare ...

**1**

vote

**2**answers

289 views

### Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where:
column A: quote number
column B: opportunity number
column C: sales order number.
One quote number will have multiple opportunity numbers. A sales ...

**0**

votes

**1**answer

315 views

### locking cell of dynamic sheet based on value range

I want to use the Excel sheet for Dynamic purpose.
Various product numbers that come from scanning barcodes need to be entered in column A. I want to ensure that if the product number entered ...

**0**

votes

**0**answers

414 views

### Using VBA how can I reassemble Excel worksheets in different workbooks while maintaing the format?

I am struggling to complete this code successfully.
Basically I have a master workbook which has defined range names. The first range is the header followed by a number of ranges (section1, section2. ...

**0**

votes

**0**answers

135 views

### Excel4Mac - can't find my VBA modules?

I have an Excel sheet with several macros, coded on a Windows machine. I used to keep the file in a dropbox folder for easy sharing with my home computer, which is a mac.
I never had any problem ...

**0**

votes

**1**answer

3k views

### Expanding only selected rows in Excel using VBA Macros

I have written the following VBA code that contains a condition where if the Cell#="Yes" then expand the bottom row, else if Cell#="No" then collapse the bottom row.
Private Sub ...

**2**

votes

**1**answer

311 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 ...

**1**

vote

**2**answers

1k views

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

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined, but only if the cell above is empty. I ...

**3**

votes

**1**answer

135 views

### How to automate transforming a table into a matrix

I've been looking for a way to automate transforming data in an Excel table into a matrix.
For example, from the left table into the matrix on the right, as shown in the following image:
Apparently ...

**-1**

votes

**1**answer

331 views

### Is it possible to build a cumulative formula that will sum on new worksheet added daily?

I have a worksheet that the user opens each day and clicks a button that copies the current sheet to a new sheet and renames (Day 1, Day 2, etc.).
I want to keep a cumulative count in some of the ...

**2**

votes

**1**answer

90 views

### Excel visual basic function across workbooks?

This seems like it should be a common issue, but I couldn't find anything on it, maybe I'm just searching for the wrong thing.
Basically I get sent a lot of workbooks that need specific modifications ...

**3**

votes

**2**answers

5k views

### How to implement MATCH and INDEX functions together in Excel VBA?

I am trying to find the row number of the first cell that is less than zero.
So, by browsing through the net I was able to come up with this formula which works perfectly fine:
...

**1**

vote

**2**answers

520 views

### Passing Range to ABS function in VBA

I would like to perform a function which looks like this
Selection.FormulaArray = "=GEOMEAN(ABS((C646:E646)))"
Since my range keeps varying I would like to pass the range as a variable which looks ...

**1**

vote

**1**answer

222 views

### Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines:
Dim Oxl_Sheet As Object
Set Oxl_Sheet = ...

**0**

votes

**2**answers

1k views

### How can I turn a Calculated Column back into a data column in an Excel Table?

I have a large Excel Table (44 columns, 1000+ rows), but one of the columns has been accidentally turned into a Calculated Column (See Here). The result being that now when the users try to add new ...

**0**

votes

**1**answer

966 views

### In Excel 2007, in VBA editor, why when I type Worksheets(1). , Excel does not list the members of the Worksheet object? (and how to fix this)

The picture that explains the question:
Notes:
I have Tools: Options: Auto List Members option selected
Ctrl+Space fails
I know that I can use the Object Browser to see, what members I can use ...

**0**

votes

**1**answer

227 views

### Find duplicate rows based on two columns and transfer results into another worksheet

I have a worksheet ("Saisie de DonnĂ©es") containing data in column B and D that are sometimes duplicates. I would like to be able to recognize these duplicates and sum the data in the columns G to V. ...

**3**

votes

**1**answer

917 views

### “The visual basic for applications (vba) macros in this workbook are corrupted and have been deleted”

Recently, I found an Excel 2007 Macro Enable Spreadsheet are keep getting the following error message:
The visual basic for applications (VBA) macros for this workbook are
corrupted and has ...

**1**

vote

**0**answers

39 views

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

Possible Duplicate:
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 ...

**2**

votes

**3**answers

8k 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 ...

**2**

votes

**1**answer

643 views

### How to copy the network path of the open workbook in Excel 2007 to the clipboard?

I want to write a VBA function for Excel 2007 (as well as Word 2007 and powerpoint 2007) which:
copies the complete network path of the open workbook or file to the clipboard.
I'm working a lot ...

**2**

votes

**3**answers

2k views

### How to store VBA Macros for Office 2007 to have them always available and share them with others?

I have created some useful VBA macros for Word, Excel Outlook and PowerPoint 2007.
Now I want to
have them always available in the corresponding application via keyboard shortcut or icon to click ...

**0**

votes

**1**answer

1k views

### 'Subscript out of range' error when selecting a range

I'm getting a VBA error (Run-time error '9': Subscript out of range) when I am trying to select a workbook and then a cell within a sheet in that workbook.
this_workbook is correct, and copying and ...