array column vba

Greetings I'm fairly new to VBA and finally require some assistance, as I can't seem to find this question on any of the forums I have a sheet with multiple columns, but only need a select few. I recently came across a method to paste an entire column in an array with a line of code that...

Hi I am dealing with thousands of rows of data. I am trying to use the multiple criteria index and match in a VBA formula to return a result. The formula I am currently using is: Selection.FormulaArray...

I am trying to make code that compare value from the list. in column AB there will be list of the values. So if user put values from AB column between F20 and last row of F, 000 value should be in the I column If that values in the AB list and not I column is matching 000 I want to give warning...

Hello and thank you for offering your help. I have 2 columns I have to compare and match. Cities and Airport Codes Each column is user defined (input by user, not pulled out of a static environment/system) which adds some tricky coding. 1. There are over 200 airport codes in this particular...

Hi I am a newbie to <acronym title="visual basic for applications">VBA</acronym> coding in Excel and this one is just too complex for me to get my head around so reaching out to this great forum I have had so much success with :smile: If you could help by providing some <acronym...

I am writing code to change the read the formatting of the cells in my worksheets. I got the code working using for loops but it takes too long running this way. So I am trying to rewrite the code using arrays . On the worksheet I am on now I have two tables that I have to loop through. Table 1...

Hi, I have a VBA code i would like to create. I have two data sets based on Transport sales. One is Adverts with Open/Close times. The second is Sale Times. Sheet 1: <TBODY> Time Open/Close Type 08:00 O Cars 08:00 O Trucks 08:00 O Bikes 08:00 O Shoes 09:30 C...

Hey All, I'm running into difficulties producing an array that will produce two separate lists based on formatting: Red - Additions , Underline - Deletions. The number of mandates and processes vary from instance to instance. See below for a visual of my inquiry: <tbody> Process A Process...

Hi, I am currently calculating ~20,000 array formulas to complete the below task, however it takes way too long to complete and often times freezes my excel (excel 2010). So I am hoping that someone can help me out and determine a faster solution (possibly with VBA) that can complete this task...

Hi All, Thank you very much for everyone who has posted to this website. I have been using it for sometime now, and finally decided to make an account because I have a question that I can not seem to answer. I have a Workbook consisting of 30 Worksheets. In each worksheet, my headers go from...

Hello all, I have my excel sheet data(i converted into array format) which looks like following 1st row......['one', , , , 'Folder', 'Folder', 'Extended Data', 'Extended Data', 'Extended Data','Extended Data' ], 2nd row.....['ID', 'Label', 'Longitude', 'Latitude', 'Country', 'City'...