All Questions
56
questions
6
votes
1
answer
388
views
Excel's Dynamic Array Functions...In VBA (No Win 32)
In recent months I have been trying to figure out how in the world one can mimic the functionality of Excel's New Dynamic Arrays exclusively in ...
- 668
3
votes
0
answers
2k
views
Alternative for VLOOKUP/Index-Match in VBA
I am sharing this function I wrote with the community to provide an alternative to slow VLOOKUP and/or Index-...
- 668
2
votes
0
answers
2k
views
VBA array functions: push, pop, shift, unshift
I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a ...
- 525
3
votes
1
answer
116
views
Array that stores values from two ranges and compares if one cell is blank
This is my first Array in VBA for Excel, but I need some help to optimize the code and try to reduce the number of If statements.
The long and short of the code is ...
- 593
2
votes
0
answers
96
views
Use arrays to perform 'VLookUp' type activity between workbooks
Background
I have the below UDF that opens a workbook (this workbook has extracted data from a queue within another app). I get the used range from this workbook and assign it to an array (...
- 121
2
votes
2
answers
235
views
Index Match implementation
The code below takes header variables, retrieves the column index, and then, using an Index/Match function, returns data from a matching account number.
The reason it is written this way is because I ...
- 131
6
votes
2
answers
112
views
Find select values on one worksheet and copy to a second
In the Calculator worksheet of my spreadsheet, for any appliance type present in a building being studied, users enter a quantity. There are 18 different appliance ...
- 419
3
votes
1
answer
487
views
Find winning move in Tic-Tac-Toe with boolean arrays in VBA
I've been trying to mess around with boolean arrays in VBA since I started to try to write an algorithm to solve sudoku puzzles. I thought I'd first try to solve codeabbey tic-tac-toe. I might be ...
- 7,159
2
votes
2
answers
194
views
Mapping one array onto another where columns from first array become rows in second array
I am processing an unformatted CSV, New-AmbSYS-to-2018-Jan.csv, from NHS England Ambulance Quality Indicators, by reading its contents into an array, and carrying out a number of steps that lead to a ...
- 375
2
votes
2
answers
2k
views
Reorder columns in Array
I am reordering columns in an array and removing one column. The mapping is as follows:
...
- 375
1
vote
2
answers
93
views
Extracting filenames from a URL by splitting a string
I am used to accessing items from an array, returned by the Split function, directly. This is lazy, I know. Usually, I know the element I want and I say something ...
- 375
1
vote
1
answer
333
views
Array Wrapper Class
I’ve wrote a small array wrapper class which mimics the built-in Collection for adding and retrieving items. Once the object is created, you set the array capacity and that would not change.
...
- 215
2
votes
2
answers
235
views
Multiply a 2D array by 1D array to get a third (2D) array
I've working with three dynamic arrays (all are datatype Double) - they are
OriningalArray
This will be assigned from a range that the end user will see and ...
- 131
5
votes
1
answer
90
views
Merging List Arrays
Some utility functions I re-wrote today:
Purpose:
Given an arbitrary list of 1-D arrays (possibly empty variables), return a
1-D array containing unique values from all lists.
Ex: Given (1,...
- 8,800
2
votes
1
answer
148
views
VLookup simulation: copying data from one sheet to another
I tried to write a VLOOKUP in my macro but for some unknown reasons it didn't work (see my post on StackOverFlow for more info.
So I decided to do a macro which achieves the same result, but it takes ...
- 121