[dba-Tech] NEVERMIND -- RE: Dynamic range in Excel

I swear, it never fails that seconds after I ask, I find what I need. 

Susan H. 

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.