# Tagged Questions

**0**

votes

**2**answers

25 views

### How can I trigger an Excel macro by hovering a mouse over a cell?

I have not been able to figure out how to run an Excel macro by moving
my mouse over one or more cells in my spreadsheet.

**0**

votes

**1**answer

22 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**0**

votes

**3**answers

74 views

### Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C.
For example, using the table below, it searching in ...

**0**

votes

**1**answer

22 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**1**

vote

**1**answer

22 views

### VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure:
Fill one cell with a formula, where arguments to ...

**0**

votes

**1**answer

28 views

### Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example:
User enters the ...

**3**

votes

**2**answers

64 views

### Creating folders and sub-folders with a VBA macro

I'm looking to use a spreadsheet I've created to generate folders and sub-folders based on what is in each column.
The first column is the top level, the second column the next level down ...

**1**

vote

**0**answers

15 views

### run-time error 1004 Application Defined or object-define error

I have this macro that I wrote:
Dim lastColumn As Long
lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug
SourceRange.Copy
...

**0**

votes

**1**answer

20 views

### Get data from another Excel file

I have an Excel spreadsheet that contains a list of usernames
Each user will have the following code. I just need to find a way to substitute First.Last with the names in the Excel spreadsheet. There ...

**-1**

votes

**1**answer

25 views

### Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...

**0**

votes

**0**answers

15 views

### Opening Numerous Closed Workbooks into One Workbook with multiple tabs/worksheets for each closed worksheet

I have a folder with 20 worksheets each worksheet conatins a scorecards which is (protected/ no password) and not in your typical table format. I want to have a macro to open all 20 of these ...

**0**

votes

**1**answer

32 views

### Insert new rows and autofill with formula

I am trying to insert new rows if a particular condition is met. I want to drag the formula from the last row to the inserted row, but I am getting an error doing so. Below is my code:
For i = 1 ...

**-2**

votes

**1**answer

32 views

### sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...

**0**

votes

**1**answer

24 views

### Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example;
| A | B | C
1|=1+2 |=2+2 |
2| | |=4-1
would display as;
| A | B | C
1|3 |4 |
2| ...

**1**

vote

**1**answer

26 views

### Excel: create folder VBA script - get value from selected cell?

I am using a VBA code to create a new folder in a directory. What I want to do is get the new folder name from the selected cell. Any ideas how I can do this please?
Here is the code I have so far.
...

**0**

votes

**1**answer

47 views

### Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...

**0**

votes

**0**answers

7 views

### Linking a cell to a specific part of an ActiveX textbox

Is there a way in Excel to have a cell refer to a specific part of an ActiveX textbox? I have a large list of references in one ActiveX text box, and in another sheet I need to input various ...

**1**

vote

**1**answer

38 views

### Working with cell addresses in excel with VBA

I have a Excel sheet in which are multiple forms. The forms look all the same and they have exact the same cells between them. They are ordered in 4 x 3:
x x x x
x x x x
x x x x
x x x x
....
There ...

**1**

vote

**1**answer

29 views

### Automatically “comment out” formula in Excel?

So I have this result set in MS SQL Management Studio. And I have an Excel sheet. I copy and paste data from MSSMS to Excel. As far as good.
Now, some of the fields start with an equals sign. Excel ...

**0**

votes

**2**answers

43 views

### How to repeat "copy range (A1:A5) to Range B with transform (column to row)?

I have a data in the Range A
1 a1
2 a2
3 a3
4 a4
5 a5
6 b1
7 b2
8 b3
9 b4
10 b5
and I copied A1 to A5 to Range B10, B1 to B5 to Range B11, C1 to C5 to Range B12 and so on with transform (from ...

**-2**

votes

**0**answers

18 views

### Adding button to Excel VB

I need help with the Excel spreadsheet.
When I click "Add Commodity" on the left hand-side I want it to show exactly those activities described on the sheet:

**-1**

votes

**1**answer

24 views

### Execute an Excel 2010 Add-In

An excel add-in seems to be the easiest way to share a macro I created with my team. I saved the workbook as a .xlam file and installed the add-in so it shows up under the addins button with a ...

**0**

votes

**1**answer

52 views

### move worksheet to another workbook, without the vba code but keeping the colour scheme

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook.
My problem is that when i copy or move a sheet it also copies the vba code that is attached ...

**0**

votes

**0**answers

63 views

### Could not load an object as it is not available on this machine - Excel 2010

Got an issue that is driving me mad. Every time a user accesses this file, he always gets the error messages: "Could not load an object as it is not available on this machine" & "Compile error in ...

**-1**

votes

**1**answer

25 views

### VBA AutoFilter gives runtime error 1004

Could anybody help me find what's wrong in the autofilter line below?
It gives run time error '1004'.
Sub filter()
Dim rng_source As Range
Set rng_source = ...

**-1**

votes

**0**answers

32 views

### Using two Private Sub Worksheet_Change(ByVal Target As Range)

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B10").Value = "0" Then
Rows("9:12").EntireRow.Hidden = True
ElseIf Range("B10").Value > 0 Then
...

**3**

votes

**3**answers

47 views

### Custom Sort using Excel without Custom List

I want to be able to sort excel rows where data looks like
Column - 1 Other Columns
701-GBL-1843-MLMK blah
566-JJB-2785-MYJW
254-WYD-3220-NAND
884-GLE-2843-FRYA
And I want ...

**0**

votes

**2**answers

23 views

### Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...

**-1**

votes

**1**answer

143 views

### How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach.
Basically as i stated in the title i need to write a macro that will copy the selected row or ...

**0**

votes

**1**answer

34 views

### Automating building a table from web sources in MS Excel 2013

I want to build a table indicating a number of things available in a given market. To do this I access the sites with relevant information and copy numbers to a table each day. I would love to ...

**0**

votes

**1**answer

21 views

### Apply a formula to an entire column since the number of rows is changing from a source file?

I have a connection to a text file source so the excel worksheet updates automatically. Therefore the number of rows is always growing every time it updates. How can I apply a formula to an entire ...

**0**

votes

**2**answers

25 views

### Error when value not present

I am using the code below several times over in one sub for different values not just "CPNEC". It works fine where there is a range with that value on the spreadsheet but falls over it the value does ...

**-1**

votes

**2**answers

79 views

### how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.

**0**

votes

**2**answers

39 views

### How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below
Column 1 Column 2
ABC123 ABC123
CDE456 ABC123
EFG789 ...

**0**

votes

**0**answers

24 views

### Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...

**0**

votes

**0**answers

22 views

### VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010
Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...

**1**

vote

**2**answers

30 views

### String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below
Original: ...

**0**

votes

**1**answer

43 views

### How to make a named cell read-only

I would like to make a cell "Cell Name" read-only.
I found this code here but don't know how to use the String value instead of the range:
Private Sub Worksheet_SelectionChange(ByVal Target As ...

**0**

votes

**0**answers

32 views

### Runtime error 9:Subscript Out of Range near end of code at “Worksheets(”UserForm“).Select”

The following code is for a userform, the user having three options, one being less than 70,000 square feet, one being between 70,000 and 150,000 square feet and one greater than 150,000 square feet. ...

**0**

votes

**2**answers

52 views

### Combine Multiple Values into Rows with Blanks

So I researched this for awhile, but I seem to be hitting a wall. I will admit- I successfully did this once, made a tutorial for my coworkers- then I nor anyone else was able to replicate the ...

**2**

votes

**1**answer

41 views

### VBA selecting range in Excel

I can set the range for all of a column such as :
ActiveSheet.Range("A:A")
But I'd like to set something such as
ActiveSheet.Range("A10:A")
but there doesn't seem to be an easy way to do this ...

**-1**

votes

**1**answer

19 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

**1**answer

25 views

### Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error
Sheets("Material").Last.Offset(0, ...

**0**

votes

**2**answers

44 views

### VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter:
Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String)
Dim mlook As ...

**0**

votes

**1**answer

23 views

### Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...

**0**

votes

**2**answers

66 views

### Adding together values from multiple spreadsheets (VBA)

In my Excel workbook, I have three separate spreadsheets. The spreadsheets are identical in format and represent count values for different categories (passenger cars, trucks, etc.). I need to combine ...

**0**

votes

**1**answer

36 views

### Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month.
Each sheet references cells in the previous sheet. For example, the "May" sheet is ...

**2**

votes

**1**answer

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

**0**

votes

**1**answer

74 views

### Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns.
For example - if the sum of E9:E12 is 0, then hide column E.
Additionally, and probably a little harder - ...

**0**

votes

**1**answer

13 views

### RE: displaying max of direct data input or cell value from formula

With reference to :
Excel - how to either have direct data input or cell value from formula
I would like to inquire on a related issue.
How would i edit my VBA formula if i would like to compare the ...