How can I in Excel VB get the Auto Filter Range from a sheet?

Next how can I can the Auto Filter Range of a specific column?

Finally how can I set for filter range in VB then return the found items and
values?

Sorry so many questions but the boos wants something done yesterday. You
know how that goes. (smile)

Thanks in advance for any help?

Mike