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?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,025
Messages
5,856,912
Members
431,837
Latest member
megantang

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