Hi all...
Can't quite figure out how to do this. I'm looking to create a macro that will delete every other row of a filtered set of data. for example, if these are the filtered rows:
row 21
row 22 delete
row 50
row 51 delete
row 58
row 59 delete.
... and so forth down to the bottom of the filter
I cant seem to record the macro using a relative reference with the filtered data
Appreciate any assistance...thanks
Last edited by jasonanthony; 10-03-2008 at 06:27 PM.
Hello jasonanthony,
This macro will delete alternate rows in a filtered range. The range used in this macro is "A2:A20". You can change this to the range you are filtering. It is marked in red.
Sincerely,
Please Login or Register to view this content.
Leith Ross
You need to check if the row you are referencing is hidden or not. Here is some sample code that illustrates the concept. I am sure you can work out what you want to do from here
RegardsPlease Login or Register to view this content.
Matt
I can work with this....thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks