VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
1
vote
1answer
8 views
Excel for Mac 2011: UBound() Not Working
I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011.
I have a function (Source) that searches arrays for a specified value:
Function ...
0
votes
0answers
9 views
Automatic Goal Seek Over Range of Cells
I want to apply goal seek across several rows when there is a change to any cell in the work sheet. I want to apply this from row 7 to row 11. The first problem I have is that excel is crashing each ...
1
vote
1answer
21 views
Add loop to vba code for excel
I know little about vba so I am hoping someone can help me.
I have the following code below, it "fill blank cells in column with value above" and works fine.
I need to use it on NON-contiguous ...
0
votes
2answers
16 views
How can I keep a VBA script referencing file names running if it cannot locate one?
I am running the code below as a means to change large batches of image names.
However, it errors out whenever an image name in the file is not located (could be due to duplicates, an accidental ...
0
votes
0answers
7 views
Track http post progress with vba
I need to post some data from an Excel worksheet to an HTTP web service with VBA.
I'm using MSXML2.XMLHTTPServer. How can I track the upload progress in order to give a feedback to the user ?
0
votes
0answers
6 views
Forcing to save xlsx format in client side from xlsm file in server side
I have myfile.xlsm formate file in server side as read only in that i wrote some VBA to file columns in excel.When client access that file i'm just showing the filled file.While client tend to save ...
0
votes
2answers
18 views
Iterate through all text (in cells, charts, textboxes) in Excel using vba
I built a function to search for and replace specific text throughout an entire excel document. I can go through the entire document and all its cells just fine using
For Each WS In Worksheets
...
0
votes
0answers
9 views
Insert values based on more than one condition
I am very new to VBA, so please be understanding.
I need a a macro to basically compare values in two different columns, but in the same row and then copy one value that it finds in the condition and ...
3
votes
2answers
23 views
Location of cell and Extract numeric value
I'm currently "trying" to setup a grid in Excel where
the user inputs a reference (e.g. HP1 or HP234) and,
I can automatically detect the cell it was entered into and the numeric value in the cell ...
1
vote
2answers
34 views
Microsoft Visual basic 6.5 Ignore case
I am using
platform: microsoft visual basic 6.5 and excel
TxtMMM is a String prompt keyyed in by user. In this case i hardcode it as an e.g
but it(TxtMMM) could be Jan, JAN, jAn or jan
My problem ...
0
votes
0answers
25 views
How to get the value greater than 0 with array formula in Excel VBA
The majority of my work is data entry and pre-data processing - I have been trying to minimize the work by Excel VBA but my kill level is really limited.
I downloaded the "DistinctValues" - Function ...
0
votes
1answer
41 views
Need help for coding in excel with VBA macros
I have kid of a big problem, or at least for me it's a big problem.
I am new at VBA and I wanted to do somehting that's possibly easy but I don't know how to.
So, for you it may be quite easy but it ...
-1
votes
2answers
42 views
Benford's Law in Excel
I have a large data set, and I was hoping to test it against Benford's Law.
So far, I have been extracting the first digit, and creating a chart based on that
=LEFT(A1,1)*1
I multiply the formula ...
2
votes
3answers
40 views
Compare two Ranges In Excel
I am trying to compare data from two ranges. "A" contains 1,2,3,4 and "B" contains 1,2,5. I want to find those that are in "B" but not in "A", which is 5. Below is my code but I can't seem to get what ...
2
votes
1answer
37 views
How can I enter a large string into an Excel cell with VBA?
I'm using Excel VBA. I have a string that I want write to a cell. I'm not sure what the actual character limitation is, but with really long ones I get a run-time error. Here's the line that the ...
