I have this code, and I dont know how to end the last loop (highlighted in red) I get the error 91
Thank youPlease Login or Register to view this content.
Marco
I have this code, and I dont know how to end the last loop (highlighted in red) I get the error 91
Thank youPlease Login or Register to view this content.
Marco
This is how I would do that, the goal is to set a "reminder" of where the first "actual" was found, then create a range of all the rows that have that until you find yourself back at the first cell again. Then you delete the entire set of rows once, greatly speeding up your resulting macro.
The part in blue goes at the top of your macro after line 1, the part in red replaces your part in red.Please Login or Register to view this content.
Last edited by JBeaucaire; 03-21-2012 at 05:39 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks