Copying a Filtered Range from a Sheet in another Workbook
 

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

Copying a Filtered Range from a Sheet in another Workbook
 

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

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

Frederick wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Copying a Filtered Range from a Sheet in another Workbook
 

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.
"Frederick" wrote in message
...
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