Creating Array in VBA from a single row and multiple columns

Hi all,

I am hoping someone will be able to help me out. I am using Excel 2010, and have a workbook with a bumber of sheets. What I need to do is create an arrray that spans a number of columns, but all the data is on a single row.

The data starts at U3 and finishes AC3. The data in each cell is a date. What I want to be able to do is take that data and create an array called Parade_Nights() with each of the dates from each of the cells.

Hopefully someone will be able to show me how to achieve this

David