Taking array values from a worksheet

Hi all,

I am currently working on a project at work where by I have to take a number of values for column A of a worksheet (The number of values changes every time the macro is run) and add them to an array. These values are then used further down the macro to filter another workbook. I understand how to use the values stored in the array and how to go through them 1 by 1, but I do not know how to fill the array in the firsty place!

Any help greatly appricated.

Thanks,
David