Optimize macro by avoiding using for statements

Hello everyone, I have read that using for statements makes a macro slow. I found this to be true because in my worksheet, I want to work with a large database in excel and I use for to loop through it. When the number of rows is big, it can take up to 15min. Anyone can suggest me better ways to do this?

The following part of the code tells me where the data starts and where it ends in the specifed sheet:

Please Login or Register  to view this content.

after I get from where my range starts and where it ends, I work with it. The following code is just an example of what I want to do just to give you the idea

Please Login or Register  to view this content.

there's more code between that, but the goal is to start with the first data in range N&x, from there, search in the rest of the range until "q" for cells that match the data in range N&x. The complete code is the following for more details:

Please Login or Register  to view this content.

I hope everything is clear, i'm pretty sure there are better ways to write that code but i'm new in programming, also the code above only has the essential things id like to improve, which are the for staments.

I'm sorry it's not really clear what you want to do.

For example in the first piece of code what are celdainicial and celdafinal supposed to refer to/represent?

Also in the 2nd/3rd pieces of code what are you trying to do?

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.