Tagged Questions
0
votes
1answer
26 views
Excel Do While Find
Below is my code that uses .Find function in excel to find the location where dodCell appears in sheet2 and to add reeCell to column 18 in sheet2 from sheet1. This is suppose to loop based on how many ...
0
votes
1answer
12 views
Trim ref text posted in Excel VBA editor
I have my following code a bit short in the process of working on it, so I am trying to get text from a .txt file to be displayed in a cell on Excel, the code will be
Sub citi()
Dim c As Range
Open ...
1
vote
3answers
28 views
Getting Type Mismatch Error
This VBA code verifies calculated cells. If the value is over $500.00 or has #N/A, then it should color the entire row and bold font.
But I keep getting this Type Mismatch error:
Dim lngCounter As ...
0
votes
1answer
26 views
Fixing a syntax error of a mid function in VBA?
I'm working in VBA excel and I'm trying to write a mid function but I keep getting a syntax error and I can't figure it out. Here's the code:
Mid=("RXOTRX", "8", "7");
-1
votes
0answers
23 views
Referencing rows for Excel in VBA
I am working on a macro right now to build load sizes for trucks. The problem I'm having is that I have 4 rows that output information for the loads. The information will only output one time ...
0
votes
1answer
20 views
Referencing pivot tables from excel 2012 in VBA
I am working on a macro right now that references a pivot table but the problem I'm having is that my reference is only for a specific cell range and I can't get it to reference the entire table as it ...
-1
votes
0answers
27 views
Challenging VBA Script: How to remove lines from excel spreadsheet when a range of data is duplicated?
I am really looking for some VBA help. I have no real knowledge of VBA, but need to get my hands dirty with a script to help automate a log of patient records I must keep track of.
The spreadsheet ...
0
votes
1answer
13 views
<Method 'Range of object' _Global' failed> - Still getting error when specifying worksheet
I am getting this VBA error even though I am referencing the worksheet that I am using in the code. I don't use VBA very often so this may be an easy question.
Sub ParseJSON()
Dim jsonText As ...
0
votes
1answer
23 views
Executing VBA out of Shell
I am generating Excel Files with Pentaho Data Integration and I want to start a Macro automaticly after creation.
Until now, the Macro is started while opening the file.
But this is not a good way: ...
-1
votes
0answers
18 views
need a macro to find single cell, copy multiple following columns from one sheet and paste it into another sheet
I have 2 sheets in a workbook.
One is the summary sheet and other is a detailed sheet
I need to update the summary sheet according to the changes made in detailed sheet for that I need to do ...
0
votes
1answer
17 views
VBA Reference of dropdown selection list
I have a code that copies all sheets from book 1 to book 2. It copies the sheets several times, so I change the names by adding 001_, 002_ and etc in front of the copied sheets names. All of the ...
2
votes
3answers
35 views
My search macro is not returning the search value
I have compiled a code that searches for a value in a excel file say for example that value is 'D0'. When i tested the Search code separately it worked. But, when i combine my search code with a code ...
0
votes
1answer
24 views
VBA Userform Find function display records
I'm in the process of making a userform. I have managed to setup a find function using the code below which then also loops and counts the number of cases in the spreadsheet.
I have also created a ...
-1
votes
1answer
20 views
Excel VBA: hide/unhide columns in day-over-day tracker, skipping weekend columns
Simple in concept hard to implement. Been trying all day with no luck.
I have a day=over-day tracker. With each new day I would like to be able to run a macro that hides the previous day and unhides ...
0
votes
1answer
38 views
vba pass a group of cells as range to function
I'm getting a group of cells and doing some calculations over them in function below.
It works if I pass a range (with : sign) as first parameter, but it fails if I choose some cells as its range ...
