Copying a Filtered Range from a Sheet in another Workbook

[Frederick]

I am afraid I am back again with another request but I know I am in good
hands.

This time what I am looking for is a snip of VBA Code to allow me (in a code
module) to set up either a filter or use the autofilter in a second workbook
then apply a filter using the Combo Box type arrows. Lets say it is
filtering "Yes" I would then like to copy the selection and paste back into
my original workbook. The Range to be Selected can be any size and will
sometimes grow or shrink. I am actually trying to build myself a Wizard and
this is one of the steps I need to cover.

If I apply this filter manually using the autofilter method I notice that
the first row in the filtered selection is 'say' Row 21, how do I set up the
copy to know it should start at Row 21 and Select only the Rows which have
been filtered bearing in mind these become quite Random. Is there an in
built VBA Method / Property I can use to do this with.


Regards Fred

 

[Debra Dalgleish]

There's some code to copy the filtered range on the following page:

http://www.contextures.com/xlautofilter03.html#Copy

 

[Frederick]

Further to my previous post I forgot to mention the Sheet being filtered in
the other worksheet starts at Row 4 because information above this is for
Colum Headers etc.