Assigning Autofiltered Range to another range

[tibetors]

Hi,

I want to transfer the an autofiltered range to another range. I've tried:

Dim Rng1 As Range
Rng1 = Sheets("CLCARD").AutoFilter.Range

But it doesn't work. How can I do this?

 

[Dustins]

Not sure what you are wanting to do here. You need the the following filter to stay on the present sheet/column and add another filter to a second column? If you already have a column filtered and then try to filter a second column, this will not work. You must select all of the columns you need to have an auto filter to or you will get errors.

 

[tibetors]

Yes, I want to back away from the first filter and do a second filter. But before that, I would like to save my first filter result in a range.

 

[Dustins]

so copy that information to a new sheet in your workbook and take the autofilter off and filter your other data.

 

[tibetors]

I do not want to copy and paste. There should be a more efficient way..