Hi all,
Just wondering if I can get some help on the code attached.
It works fine as far as finding & deleting required line, one line at a time, but I can't work out how to get it to loop through the whole sheet.
any help would be appreciated
HTML Code:
Last edited by nighttrainrex; 10-09-2013 at 12:49 AM. Reason: Change thread title
Hi, nighttrainrex,
you could use the Autofilter for this as well.
Command would be FindNext after the first found. Assign the address of the first range for find to a string and use a Do...Loop to run FindNext, compare the address of the new Find with the first one.
There is no need to select the rnage before deleteing.
And maybe you should consider changing the thread title.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Try this code...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Holger,
Thanks for the quick reply title changed.
I have very little knowledge with this, the code I have I have pieced together from ones I found on here.
I get the bit about not selecting the range but am lost when it comes to the loop & find next bits.
Rex
Hi,m Rex,
I still stand for Autofilter to be the faster way to get the problem solved. Here youŽll find an example and right below arlu1201 has posted a code for using Autofilter.
Ciao,
Holger
Hi Sixthsense,
Thanks that worked a treat.
Appreciate the help.
Thanks Holger,
I will have a look at the post.
As I am learning (fumbling) my way along all the help/info I can pick up is fantastic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks