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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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,144,510
Messages
5,724,773
Members
422,577
Latest member
kayth891

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