View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter[_61_] Peter[_61_] is offline
external usenet poster
 
Posts: 48
Default Autofilter cut and paste

On 28 Feb, 14:33, Tom Ogilvy
wrote:
Start out by turning the macro recorder on and performing the action
manually. Turn off the macro recorder and look at the recorded code. Modify
it to suit your needs.

--
Regards,
Tom Ogilvy



"Peter" wrote:
I am trying to autofilter the AI column and then cut the results and
send them to another file. Does anyone have any idea how to do this?


Thanks for your help,


Peter- Hide quoted text -


- Show quoted text -


Hi Tom,

When I cut the filtered selection, it also cuts the non-filtered rows,
any ideas?