I am having some trouble getting started with Arrays. I know what I want to do but can't seem to get off the ground wiht this one ...

I need to create 4 global arrays where i know the column count but the row size ma vary
(I have tried multipe was to set this up on Excel 2010 but cant do it)

Once I have each array read to go I wanted to populate it with my table data using specific columns and all the avaialble rows ...

Narritave Example --> ArryFirst = (all rows and only columns 1,2,3,4,8,12,16,20)
--> ArrySecond = (all rows and only columns 1,2,3,5,9,13,17,21)

Once I have the Arry's built and populated I need them to remain global so I can call on the data and make various caculations

Also as a side problem, I can only access my data sheet by making it the active sheet ... I tried using "With Sheets" but got an error.

Thanks in advance for your help.