Tagged Questions
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 ...
0
votes
1answer
25 views
Macro to read cells in one sheet and then search for match in another sheet and add date to column
I'm trying to write an excel macro that will go down a column of text and then search for each item in the column in another spreadsheet in the same workbook. When the value is found it should put ...
3
votes
1answer
79 views
Passing arrays from VBA to VB.NET
I am working on a vb.net COM interop to work in Microsoft Excel and I am having trouble passing arrays from vb to vb.net. I have a PointPairs property in the vb.net code that I need to set from vb and ...
0
votes
1answer
4k views
VBA Excel Store Range as Array, extract cell values for formula. Offset for other variables
I'm a bit new at this. How would I take the column and put the cell data of which is an integer and go through all values in that range to put it into a function to output the result into another ...
11
votes
8answers
917 views
Is it possible to fill an array with row numbers which match a certain criteria in Excel VBA without looping through them?
I would like to fill an array in vba with the row numbers of only rows which meet a certain criteria. I would like the fastest method possible (for example, something like RowArray = ...
1
vote
1answer
42 views
Reference Variant Array to Column
I have code that prevents changes to more than one cell at once. It will however allow for more than one cell to be deleted at a time. Below is the code that I am using and it works well.
Dim vClear ...
1
vote
1answer
34 views
Why did my VBA array contents disappear when I wanted to reuse them?
I am a newbie to VBA and have been developing a macro that involves arrays.
In the array part, I need to copy some ranges from two excel workbooks into two separate arrays(timearray and guzikarray). ...
0
votes
4answers
82 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
110 views
How to fill in a dynamic combination of numbers into an array
In my Excel worksheet users can enter 1 to 5 rows of data in the form of minimum, maximum and step size values. I want to create an multidimensional array that has all the combinations of the data.
...
0
votes
0answers
40 views
How to call a DLL from VB with pointer to array
sorry if this is a silly question, but I'm a newbie in C and VB.
I would like to use a dll written in c++ inside a vba function.
My aim is to pass an array to the dll function, and have its items ...
0
votes
1answer
89 views
Creating an array of checkbox names
I'm having some trouble with creating an array of activex checkbox names. I want to create this array so I can use a For loop instead of having to type each checkbox code out separately. Here is what ...
0
votes
0answers
59 views
VBA return Array from a function producing error on function call - only user defined types
OK, I'm well and truly stumped now, so hope someone out there can help.
I have a function which collects data from various record sets, collates the data into a custom data type, then stores ...
0
votes
1answer
32 views
Excel VBA Group Variables together and perform For Each in the group
and thank you to anyone who takes the time to help me out with this!
I am writing a code that encompasses a group of about 11 Arrays. I want to perform the same action on the respective element in ...
0
votes
1answer
678 views
Excel VBA Find Values through while loop, store in array, and pass to different sub
First off, I appreciate any help anyone can offer. I am writing a macro that will give the user a form to input a number key. The form will search a spreadsheet for the key and return the ...
0
votes
1answer
46 views
Type mismatch error for large array
I am getting this VBA error of Type Mismatch on Line 3, but it works very well if the array is shorter like A3:A52. Is it because there is limited on array size?
Dim varry() As Variant
varry = ...
