[dba-Tech] Dynamic range in Excel

I want to select a range and then use VBA to create a list of all the
content in that range. I can't remember how to tell VBA to work with the
selected range -- I don't want to hard code a reference. I'm positive I've
done this before, but I just can't find it. I can't even get close enough in
Help to find it. 

Thanks!
Susan H.