Find text in a range, select said cell. then continue searching in the range from there

Hello,

I have found thousands of posts on how to find text (say "DueNow") within a column and then .Select that cell.
However, I have yet to see a post that will find the next instants of "Due Now" and .Select that cell. and so on and so on.
The code below works to get to the first instance of "Due Now" within the range, but if i run the code again, it does not move down the column.

I think it has something to do with excel starts at the top of the row everytime versus starting from the row that is currently selected (say G450).

I simply want it to continue down the column from whatever row I am currently at.

Please Login or Register  to view this content.

I appreciate any help.
Thank you.

Thanks nankw83,

But this won't work because I will not be on the cell when I rerun the code. This would work if it would continue searching the range starting from the row that I'm on.

Is that possible?

Any cell in a row that i have changed. I am using this to work through a sheet and make changes from top to bottom.

I just need a macro that looks for "Due Now" in a range and selects the cell containing it without starting from the top again.

So if cell U344 has Due Now (the code takes me to that cell), then and I make changes in another cell (maybe cell T360), then when I rerun the code it should start searching down in range U:X from row 360.

Your suggestion works perfect if I stay in that Range, but I most likely will be in another area of the spreadsheet.

That's why I think that I have to tell excel to start searching in the range of U:X, beginning from the active row.

I hope this helps.

I know, but what if the currently selected cell is on the same row but located to the right of a cell with "Due Now" in it... is the code supposed to go back to it or move on to the next cell with "Due Now" in it?

Also, could a single row contain more than one cell with "Due Now" in it?

Finally, would it be alright to start from the beginning again whenever Excel is opened? In other words, would it be acceptable for the code to keep moving on as you asked while Excel is open, but if you close Excel and open it again later, the code would start searching from cell A1 onward.

Thanks Rick,

1. It can move on to the next Due Now
2. There will not be more then 1 Due Now on a row
3. It could start over when I reopen Excel but only if I run the code manually.

I hope this helps.

This macro will go through each "Due Now" cell continuing from the last cell found with "Due Now" in it no matter where the active cell is located at the time. Is that what you were asking for initially?

Please Login or Register  to view this content.

I'm getting..

Run-Time Error 1004
Application-defined or Object-defined error

On this line?

Set LastFoundCell = Columns("A1:A10000").Find("Due Now", LastFoundCell, xlValues, xlWhole, , xlNext, False, , False)

Hey Rick,

It runs fine if the Due Now is typed in the cell. However the Due Now is in a formula. I see you have xlValues in the code so I would think it would work?

Rick, I see the errors of my ways.
This code works great!

Thank you!