Refining a Find Statement

**Jordan Kidd** · 07-01-2010, 12:22 PM

I have part of a program which is creating a range based on the first x continuous cells that contain data. I currently am using a find statement, but it seems to slow down the program a lot. Is there a better way to either define a range, or to chose cells only until the last row of the worksheet? I have attached the section of code which I am currently using.

Please Login or Register  to view this content.

**shg** · 07-01-2010, 12:28 PM

Are you doing that once, or inside a loop?

**StephenR** · 07-01-2010, 12:28 PM

You don't say where you are searching, but this example will search just col A values.

Please Login or Register  to view this content.

**Jordan Kidd** · 07-01-2010, 12:30 PM

Sorry. Inside a loop. Here is the full loop's code

Please Login or Register  to view this content.

**Jordan Kidd** · 07-01-2010, 12:34 PM

I am not really searching for anything particular. I just want to insert the mm/dd/yy all the way down the sheet until I get to the last row, which is indicated by column A. (last row is the one before beginning of blank rows)

**StephenR** · 07-01-2010, 12:35 PM

Is there a better way to either define a range, or to chose cells only until the last row of the worksheet?

That's the question you asked.

**shg** · 07-01-2010, 12:39 PM

I don't understand what you're doing at all. Maybe post a workbook and explain in context.

**Jordan Kidd** · 07-01-2010, 12:40 PM

Sorry, I didn't mean the last row of the worksheet, I meant until the last row containing data. Do I really need to define range, or is there a better way to set how far the mm/dd/yy from the preceding code can be inserted to the specified cells?

**Jordan Kidd** · 07-01-2010, 12:59 PM

The workbook which I am using is too big to upload. I have attached the code for the whole module. I hope we can make sense of this.

Please Login or Register  to view this content.

**StephenR** · 07-01-2010, 01:51 PM

You don't have to post your actual workbook. Add some dummy data, enough for us to understand what you are doing. This always helps.

**Jordan Kidd** · 07-01-2010, 02:01 PM

I greatly appreciate it. I have attached one sheet which shows where the above code is running.

**StephenR** · 07-02-2010, 08:06 AM

Still not sure what you're doing. Can you explain a bit more, or illustrate in your workbook? I can't really replicate your situation as you are using different workbooks. What should the worksheet you attached end up looking like?