You can use Criteria like this
"=*SetOut*" Rajan. From: [email protected] [mailto:[email protected]] On Behalf Of Cab Boose Sent: Apr/Fri/2012 01:36 To: [email protected] Subject: $$Excel-Macros$$ Deleteing Rows based on single column contents Hi In worbook attached I am deleting rows based on contents of column C. When I use as it is set up at the moment it works as it should and deletes rows with SETOUTS in them. That is good. However, in a second similiar macro, I also want to delete rows that have in column C this : *************** but as it is a wildcard character I am having difficulty to get it to work. Usually deletes most of the sheet. How do I tell in the macro that the last asterix is the wild card and that previous asterix are what is in the cell ? and that is a row to delete. A similiar thing is there are a lot of rows that have 6 spaces and then some text, text varies and unknown. I have tried putting in 6 spaces and * ( *) or (* ) like that but to know available. how do you allow for spaces preceding unknown text ? A model railroad project. Thanks and regards Charlie -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to [email protected] -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to [email protected]
