Assigning Autofiltered Range to another range

tibetors

Board Regular
Joined
Oct 30, 2013
Messages
52
Hi,

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

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

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

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Dustins

New Member
Joined
Dec 4, 2013
Messages
22
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

Board Regular
Joined
Oct 30, 2013
Messages
52
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

New Member
Joined
Dec 4, 2013
Messages
22
so copy that information to a new sheet in your workbook and take the autofilter off and filter your other data.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,573
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top