LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default how to select rows after autofilter

The following commands make a part of macro I'm trying to complete

Selection.AutoFilter Field:=24, Criteria1:="="
Rows("10:1186").Select
Selection.Delete Shift:=xlUp

The first line specifies an autofilter and a criteria that generates
an output typical of the autofilter function.

This next two commands selects and deletes all the rows (and then some
for good measure, hence the 1186) that need to be deleted. These lines
were generated during a "record macro", hence the explicit 10:1186.

Now it is expected that the starting row to delete will not always be
row 10 due to the variability of the content of the rows before the
filter is applied (well duh!)

So, my question is, how is the filter output more generically selected
so that all any rows from the filter output result will be deleted?

Thanks for any suggestions!

John Keith

 
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
Select cells after Autofilter Haris Excel Worksheet Functions 2 October 28th 07 09:48 PM
Scroll home after Autofilter select Steve Excel Programming 3 August 1st 07 12:24 AM
Select first field whilst autofilter is on bony_tony Excel Programming 1 May 4th 07 03:58 AM
autofilter, command to select filtered range? matthias Excel Programming 1 October 16th 06 11:28 AM
Autofilter - on select columns rudawg Excel Worksheet Functions 8 January 31st 06 06:20 AM


All times are GMT +1. The time now is 07:20 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"