advancedfilter paste values

keithkemble

Board Regular
Joined
Feb 15, 2002
Messages
160
I am having difficulty in being able to paste the output of the filter to the destination as a value.
Can anyone help please?


Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.Copy Destination:=Sheets("exceptions").Range("A10")

Thanks
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
To paste as values you need to first do this

Selection.Copy

and then, in the destination, use the PasteSpecial method of the Range.
 

keithkemble

Board Regular
Joined
Feb 15, 2002
Messages
160
I tried that method but it would not activate.
Should there be a , or a . after the Range statement,

Should the copy selection be on a separate line to the destination?
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
On 2002-10-13 16:07, keithkemble wrote:
I am having difficulty in being able to paste the output of the filter to the destination as a value.
Can anyone help please?


Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.Copy Destination:=Sheets("exceptions").Range("A10")

Thanks

Hi keithkemble:

Try ...

Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.Copy
Sheets("exceptions").Select
Range("A10").Select
ActiveSheet.Paste

Regards!

Yogi
 

Forum statistics

Threads
1,181,919
Messages
5,932,785
Members
436,861
Latest member
eh19

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