LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Delte Autofiltered

Hi

See This example that copy the cells.
You can adapt it to delete
http://www.contextures.com/xlautofilter03.html#Copy


If you filter on one column you can use this Add-in
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"scrabtree23" wrote in message ...
Here is an additional need:

I have a table of data that I autofilter by several criteria. I want a VBA
that will delte and shift up all the autofiltered data except the top row
(1:1).



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find and delte duplicates Nick Excel Worksheet Functions 2 July 27th 09 03:34 PM
How to delte macros in another workbook Vinod[_2_] Excel Discussion (Misc queries) 0 August 11th 08 12:14 PM
How to Delte Multiple Rows Given a Value Existing Jako[_89_] Excel Programming 0 October 23rd 04 09:52 AM
How to Delte Multiple Rows Given a Value Existing Jako[_88_] Excel Programming 1 October 22nd 04 11:34 PM
DELTE RANGE NAMES gus Excel Programming 2 September 22nd 03 02:20 PM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"