I know that this is relatively easy, but it has been years since I have done any Excel VBA. I am parsing out some firewall rules, and in order to compare lines, I need to remove a section of text from within a string.
The strings will look like this: access-list BldA-I line 5 remark 10/19/2011 permit tcp host computer1 host computer2 eq 80 I need to remove the section of text that reads "remark 10/19/2011". There could be 1000+ lines, so I need to be able to loop the code until there all of the remarks have been removed. Any help is appreciated! Z -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
