Tagged Questions
0
votes
2answers
26 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
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 ...
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 ...
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 ...
-2
votes
1answer
30 views
How to locate a specific Tag whose position is not same in each excel files and read the measured value column for that specific tag
I have 1000 Excel files which I have narrowed down to 100, but in those 100 files my search has to look for a particular id tag.
Let me explain, each Excel file has different id tags, these tags ...
1
vote
1answer
24 views
Getting ActiveCell value in excel FROM word macro
I am trying to manipulate an excel workbook from word. Everything was working quite well until all of a sudden I couldn't get a response from ActiveCell.Value
The problem is happening all the way at ...
0
votes
0answers
31 views
Reference a cell based on embeded button location
The user can enter certain parameters and it will pull up an array of cells fitting those parameters in 3 separate columns. I need to reference those cells based on the row my form control button is ...
2
votes
1answer
22 views
FormatConditions border on a single edge
I am trying to add a border between rows when the data in column 1 changes. This code breaks at .LineStyle = xlContinuous. The error I get is "Unable to set the LineStyle property of the Border ...
0
votes
3answers
41 views
object required error Sheet1
Sub combine()
Dim inName, inNum, inCity As String
Dim IncNum As Integer
Dim temp As Range
Dim lrow As Long
Dim counter As Integer
Dim cityCells, sNameCells, sNumCells As ...
0
votes
1answer
54 views
Faster way to add formatting
I have 234,000 rows of data and a macro that applies formatting to it. The macro takes about a minute to run. I'm trying to cut the time down if possible.
Each time there is a change in column 1 a ...
0
votes
1answer
28 views
Method name of object _chart failed
I am getting a Run Time error 1004 :Method name of object _chart failed while I try to name my chart. Sometimes this runs, and sometimes it doesn't. Here is the part that causes the error, (the whole ...
0
votes
3answers
37 views
Setting a delimiter to generate an export
I found a VBA code that almost fits my requirements to export data to a CSV file. I am having problems with the delimiter function.
I have the following function:
Function DelimitRange(ByVal XLArray ...
0
votes
2answers
53 views
Get and edit a file directory
I'm looking to retreive the directory of a txt file and then remove it's filetype suffix.
The reason for this is so I can input additional text to the file name (which will be Saved As, later in the ...
0
votes
1answer
29 views
split orasql query into multiple workbooks in Excel using VBA
I am trying to split my ORASQL query into multiple workbooks with a specified number of entries for each book. I am using office 2010 if that matters. I think I should use what is below (from a ...
