Hi,

i need help on populating an array in one of my subroutine from a range from a closed work book.

the workbook is in c:\drive under a folder.

is it possible to get the desired range say A1:A30 to an array?

Thanks for any help in advance
Raj