New to arrays-Create two column array with different column order to sheet?

UPDATE: Yes, I know the obvious solution is to alter the worksheet column order instead. But I can't (long story) hence this thread.

I am new to arrays and wish to achieve the following:

I have worksheet range in Column A & Column B that I want to read into an array of 2 columns wide, X (variable) rows deep. Now for the catch. I need the array to have Column B data in the first array column and Column A data in the second array column.

How do I do this? (short of slowly building the array individual record by individual record)

• Would it be possible to copy A & B columns and then transpose the column order in the array? (Don't laugh. I am new to arrays).
• Would it be possible to somehow read Column B values and then Column A values when creating the array?
• Messier. Would it be easier to build two arrays (one column each) and then 'join' these together in the order I want??

thanks for the reply nilem but the code you provided switches the columns on the sheet.

I wish to read the sheet values (not reading by individual values e.g. For/Next) then switch the array columns.

Am marking this thread as solved. (I only needed this column order in the vba array to make a VLOOKUP possible but this was unnecessary - it was resolved through an alternative approach)

you can also do this using application.index

Please Login or Register  to view this content.