vba array

Dear all master, I want to merge multiple dbf file drive folders into one with access, sql and vba scripting.dictionary & array because of thousands of data records. the map drive that I mean is as follows : Z:\DATA\Malfin 07\NOW\IFG.DBF Z:\DATA\Malfin 07\NOW\GSD.DBF Z:\DATA\Malfin...

Hello guys, I've been struggling to write this for days macro and I have finally decided to ask for your help. Here's what I have: Sheet1 - Job IDs, Assignees and Tasks as headers A1 - IDs B1 - Assignees C1 - Tasks *Rest of the columns are something i've tried which did not work...

Hi Guys, and Happy New Year to everybody! I am trying to build something like a widget. I created shapes that are named in this fashion: A01_TrafficLight, A02_TrafficLight, B03_TrafficLight etc... I have the corresponding list of names in a named range on a sheet ie: A01, A02, B03... How can I...

I have an array with orders (order date, customer etc) and I need to check whether a specific ID corresponds to a customer. Here is the function / data below: Function CheckCustomer(ID As Integer, Customer As Integer) as Boolean Dim arr() As Variant Dim ws As Worksheet Set ws =...

Hoping someone can help, I'm having an issue with my code. I'm using an error handler so not able to clarify the error itself. Sheet 1 - This is the list that I am attempting to categorise with my worksheetfunction.search, as my data is sensitive I have decided to use my breakfast as the...

Hi I'm amending some code written by a colleague who's now left. The code is used to change the column order of some data in excel and the column headers are contained within an array in the code. I've added 1 extra header in to the array but when I run the code it's now doesn't re order all...

I have two spreadsheet columns of non-contiguous data. Column B is the "key" column. VBA rng1 consists of cells where there is text in Column B cells. Trying to create VBA rng2 which consists of rng1 cells and the adjacent Column A cells. Next is to then populate two array columns with each...

Hello friends of mrexcel! I am currently trying to wrap my head around arrays! I have data written into cells on a worksheet. Each cell holds "rows" and "columns" I would like to write into an array. The "rows" are separated by "/" and the columns are separated by ",". An example of a...

I am having trouble working with a 2 dimensional array. I have worked with a 1D array before, no problem. The Named Table I am loading from is called "EA-Libraries_Data", and it contains the list of the other tables on the same sheet that need to be populated. There are 3 tables. The second...

I have written arrays to populate the following information: 1) the number in the 1st cell in the range containing a NUMBER to F5: {=INDEX(N5:AR5,MATCH(TRUE,ISNUMBER(N5:AR5),0))} 2) the number in the cell at the top of the page that corresponds with the cell found by this array to E5...

Hi All, I am a newbie to VBA programming and I am very much interested to correct my mistakes However, I am unable to solve a problem that involves calculation of Weekdays and storing them in an array Excel Version: 2007 Problem : Column A Column B Column C 16-May-13 19-May-13 In the...

Hi, in one sheet I have data like: A1: Audi B1:A3 A2: BMW B2:Z300 A3: Ford B3:Fiesta A4: Audi B4: A4 A5: Ford B5: Mondeo in second sheet I have unique value: A1: Audi A2: BMW A3: Ford Now I want to insert into second sheet in B1, B2... all value from sheet1 for Audi, Ford etc...: B1: A3, A4...

How can I get something like the OFFSET -function to work in a VBA array? I'm trying to come up with a UDF that counts the days between two weekdays. My function gets three arguments, starting day as a string and ending day as a string and the third one is minimum number of days between those...

Hi, I have two arrays: Dim arr_1 (1000) Dim arr_2 (1000) arr_1 = {abc, xyz, mnc} arr_2 = {abc, xyz, pqr} I want VBA code that compares both arrays and string found in arr_1 but not found in arr_2 should pop up in message box. so here mesg box should pop-up "mnc" please help.....thanks...

Hi All, I have an array basically like this Dim arr(1 to 500) For i = 1 to 500 Is there any way I can use part of it to make a calculation? For example I want to calculate the average on the first 250 values, so i=1 to i=250? Any help is greatly appreciated Cheers

I am having trouble finding a built in function the will allow me to collect a formula from a cell as an array of its arguments. For example, is a cell has "=sum(A1,G4,L3)", i want an array of 3 with values A1, G4, L3. My goal is to be able to change each argument as i please and return the...