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

You can assign a range directly to a variant and create an array that way. It will always be a two dimensional array, even if it is just one row or column.

Please Login or Register  to view this content.

by way of example.

You simply need to qualify the range with a worksheet object

Please Login or Register  to view this content.