Good afternoon - I have a stupid question for the VBA gurus:

I have some code that takes a file list of pdf documents and merges
the listed documents together. This works great, with the exception
that I have "hardcoded" the file list in the array variable.

What I would like to do is have the user select a list of pdf file
paths in Excel, then have some code that convert what is currently
selected into the array variable so that the rests of the code may
continue.

In other words, I currently have
myArray("c:\test1.pdf", "c:\test2.pdf", "c:\test3.pdf")

I can't figure out the code to take a selected list of files from
excel into this array. Say the file list is A1:A3 -
A1 - c:\test1.pdf
A2 - c:\test2.pdf
A3 - c:\test3.pdf
If the user selects these 3 cells, I'd like them to be able to click a
command button which will kick of the merge program, and pass the
contents of what is selected to myArray, as listed above.

Help??
Brian Limbert