Tagged Questions
0
votes
3answers
27 views
Copying Row Info from one sheet to another based on match
I have an excel book that has two sheets: 1) Import 2) Pricing Rules.
Pricing Rules Sheet
The A column is what I need to match on. Example values include STA_PNP4, STA_PST.. and others. There are ...
0
votes
1answer
15 views
Rolling Date Macro
I'm currently using Office 2003 to create a rolling forecast. I have a starting point and end point for a time interval (yr/month to yr/month) that I need to populate automatically at certain ...
2
votes
3answers
935 views
insert rows after a data point changes
I have a data set that looks like this:
This1 GH
This2 GH
This3 GH
This4 BR
This5 BR
This6 VB
when the data point changes, i.e. "GH" to "BR" I want excel to insert a line break. ...
2
votes
2answers
56 views
Select Case Loop
I modeled a Select Case loop based on another question I found on here(Link: Excel VBA Select Case Loop Sub).
The changes I had to do to make it applicable were pretty minimal, and I don't see where ...
1
vote
2answers
16 views
Auto populate columns in one sheet from another sheet
I would like to populate columns in sheet2 from sheet1. If I have column A in Sheet1 I want A in Sheet2 to have the same information.
I tried using =sheet1!A1 but it only returns the value from A1 in ...
0
votes
2answers
33 views
How to build non-consecutive ranges of rows based on cell contents?
I'm just getting started with VBA for Excel. I used VB and Java in college nearly ten years ago and was competent with it then, but am essentially starting over. (Um, not like riding a bike.)
I am ...
0
votes
1answer
2k views
Excel VBA: Looping through rows and copy cell values to another worksheet
Facing some diffculty in achieving the desired result for my macro.
Intention:
I have a list of data in sheets(input).column A(the number of rows that has value will vary and hence i created a loop ...
0
votes
1answer
136 views
Excel VBA - PivotTable Filter Runtime Error '1004' PivotItems
I have the following code, which opens an excel file, selects the sheet and runs a macro - I have then managed to make it remove the filter for Date, but I am then having trouble getting it to filter ...
0
votes
3answers
31 views
Delete entire row if value is greater than or less than?
I am new to VBA for excel and I am stuck with a little problem. I have to delete an entire row if the value in column C is greater than 40000 or less than -40000 (these are data outliers). The list of ...
0
votes
2answers
33 views
Searching for matching cells and copying row data
I'm very new to Visual Basic, so I apologize if this is a basic question.
I have two excel documents, one with a list of company names and their corresponding identifying numbers (about 4000 in ...
3
votes
1answer
48 views
Passing different types of arrays to an UDF function
I have a function that show the content of an array in excel sheet. The header of my function looks like this :
Public Sub afficher_signal(ByRef signal() As Integer, ByVal nb_ligne As Integer)
The ...
1
vote
3answers
41 views
Setting maximum and minimum values for x-axis in Excel
I have a graph that has dates on the x-axis and I'm trying to set maximum and minimum values for this axis using an Excel VBA. I defined MinXAxis and MaxXAxis values in the same sheet and here is my ...
11
votes
2answers
4k views
Multi-threading in VBA
Does anybody here know how to get VBA to run multiple threads? I am using Excel.
-1
votes
1answer
35 views
create exit button in excel 2010
I have an excel 2003 application which contains an user defined exit button.How can i implement the same in excel 2010.
Set NewBtn = TBar.Controls.Add(msoControlButton)
With NewBtn
...
1
vote
4answers
40 views
Display 3 values in a message box with spaces between the values
I am trying to display 3 values in a MsgBox.
My logic statements are working, and it is picking the correct values I want - however I am unable to make my message box display 3 separate values with ...
