Tagged Questions
0
votes
4answers
61 views
For-Next Loop and Arrays - VBA
I keep making the same mistake, and I have no idea what it is. Every time I make a For-Loop dealing with arrays (usually, trying to read one array and write the values in a second array), it just ...
0
votes
1answer
36 views
EXCEL VBA Error: “Compile Error: Expected Array”
Can anyone help me?
I have been getting a compile error (...: "Expected Array") when dealing with arrays in my Excel workbook.
Basically, I have one 'mother' array (2D, Variant type) and four ...
0
votes
0answers
29 views
How to loop through a excel table and print out values on another sheet?
I have no experience in excel VBA but have a good amount in C++. My problem seems pretty simple. What I would like to do is write a macro to loop through a range of cells by changing the next cell to ...
1
vote
1answer
37 views
Excel - VBA : deal with elements of an array when looking for matches
I am working on a program whose purpose is to identify parts of an address in a database. The input is a column, each cell containing one word / number from the address. On the other hand, in the ...
1
vote
1answer
22 views
Auto create Excel sheets from Array values
I am relatively new to vba. I have used VB a long time ago so I derive a lot of info from that experience. Though now I'm facing a harder task and I don't quite know how to do it.
I have got a data ...
1
vote
1answer
21 views
Cannot initialize the value of an array in VBA
I am still new to VBA. here is the code:
Sub Macro1()
Dim NumberSeq() As Integer = {1,2,3,4}
End Sub
It's just the initialization of an array and I saw it work for others. But I always get the ...
0
votes
2answers
33 views
Delete ALL duplicate rows based on multiple columns
The code below is currently deleting all duplicate occurances, including the original, found in column A. I would like to modify the code below to delete all duplicates based on columns A, B, C & ...
1
vote
0answers
41 views
Simple Hash Table Excel VBA
Gents,
I'm a long user of arrays in VBA but I recently learned a bit about hashing and I was wondering if I could use that to build more efficient searches in my arrays. To keep it specific, what I ...
1
vote
1answer
23 views
Specific referenc on one Array-element in an 2D-Array in VBA
i wanna have a reference on one element in a 2 dimensional Array like this:
dim ary(5,5) as String
ary(1) = "Michael, Thomas, Bill, Mike, Pascal"
ary(2) = "Iphone,HTCOne,SGS4,SGS3"
...
1
vote
1answer
39 views
Working with Arrays in Classes (Excel VBA)
I'm working on a part of a program that does the following:
1) Determines there is an "X" in a certain cell and whether the header matches the user input
2) Adds the contents of the header to an ...
0
votes
2answers
34 views
Output an Array or List to String
I wrote the following piece of code (in VBA in outlook) to try to output my list to a string. This way may not be perfect; it compiles, but I have not tested it yet; in any case, I'm wondering if any ...
0
votes
0answers
36 views
Invalid Qualifier for String.Add in Outlook VBA
You all have been so helpful, and I was wondering whether I might trouble you a bit more. I have nearly completed my conversion from VB.net to VBA for Outlook, and in order to complete that, I need ...
-1
votes
1answer
73 views
lists and arrays in VBA
I am extremely new at writing in VB.NET, and I did not even realise that there was a significant difference between VB.NET and VBA. I have been writing my application in Visual Studio, but I realised ...
0
votes
0answers
41 views
VBA complex Array filling
I have a bit of a complex problem.
My set of Data consists of Customers that purchase on certain dates. The customers are identified by their email adress. Now I want to find out which customer has ...
2
votes
1answer
56 views
Comparing two Arrays with excel VBA
I need some assistance with my excel VBA project. Now, I know this has been asked before, but I couldn't find an answer that I fully understood. I'm fairly new to VBa and so some parts are just Hebrew ...
