Hi,
I have a userform in a master file that inputs a list of .xl file names into
a column(K) in a worksheet(Selection Properties), the list could contain any
number of .xl file names( from K2 to column("K").end(xldown)). What I want to
do is to open all these files, copy all information on sheet 1 in these files
and paste all into one worksheet in the current master excel file. I am
having difficulty with the code for opening the possible range of values in
column "K".
Thanks for your time