Avi,

Then you will need to loop through the cells as shown and assign the values
to the array, after using redim on the array to set the size.

Bernie

"avi" wrote in message
...
Thanks but I really need it as an array for the rest of my application
Avi