Slow Macro Execution

I created a macro to retrieve data from a worksheet based on the contents of a cell within the same workbook. However, the macro runs slowly at first then gets slower. The workbook has several worksheets but I am only using 2. I import customer data into Sheets(1) and have my search data formatted as text - this is a column of numbers which I do not want to treat as numbers. The search numbers in Sheets(1) are a subset of the complete number in Sheets(2). For example, in Sheets(1), I use 062825 to search Sheets(2) to find 011874000061825. Numbers in both sheets are formatted as text.

I sort both sheets on the data value I am interested in then use a For..Next loop to grab each input value and search Sheets(2). I included a code fragment below for evaluation. All variables are initialized prior to For loop. At this time, Sheets(1) has 250 lines while Sheets(2) has approx 1357 lines.

Any comments will be appreciated.

Please Login or Register  to view this content.

Thank you
Gandalf2524

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.