Search Value

**watzmann** · 07-29-2009, 02:21 AM

Hi All,

I have a problem with this code , i'm trying to find a value on a sheet and once i find it i offset my selection to a cell of a figure and copy this figure to another cell.

my problem is , i need to resume the search from the last founded figure ,

how to do that ?

Please Login or Register  to view this content.

i have recieved this code but it doesn't work

Please Login or Register  to view this content.

**watzmann** · 07-29-2009, 04:56 AM

I have modified my code to this one ,

the new problem is it's just work for one step and stop , that mean i think my loop doens't work fine .

Please Login or Register  to view this content.

**Phil_V** · 07-29-2009, 05:09 AM

Hi, that second section of code was from me, and it works fine for what you said you were doing in the post where you asked for it. However for the problem you have here you do not need it.
In your original code you don't need to be activating, or selecting cells to do the core functions, just at the end when you want the selection moved to the cell that was found (for some reason), so it would need to be like this:

Please Login or Register  to view this content.

EDIT
I see you have made another post. It doesn't help people to help you when you keep changing the code function!
The first code you posted has no looping, the second code has suddenly got a loop in it, and the absolute destination of "AC12" has turned variable.

Please detail, (in words, not code), what EXACTLY you are trying to achieve, and THEN we can offer assistance.

**watzmann** · 07-29-2009, 05:17 AM

but i need also to use this code section because i exepect many values and i need to list all of them in order .

but i don't know why it just goes for one step and stop

Please Login or Register  to view this content.

**watzmann** · 07-29-2009, 05:22 AM

now i modified to this but i got an error : " object required "

Please Login or Register  to view this content.

**Phil_V** · 07-29-2009, 05:55 AM

I'll ask again, WHAT are you trying to achieve?

Find each occurance of "ASK Training Managers", and for each occurance copy the value that is at an offset of -5 rows, and + 2 columns into a list that starts at "AD20", and works it's way down for each value?

**watzmann** · 07-29-2009, 06:32 AM

Find each occurance of "ASK Training Managers", and for each occurance copy the value that is at an offset of -5 rows, and + 2 columns into a list that starts at "AD20", and works it's way down for each value?

exactly that's what i'm doing

**Phil_V** · 07-29-2009, 06:47 AM

In that case try the following. Using 'Select' and 'Activate' the way that you are will only serve to tie you in knots

Please Login or Register  to view this content.

**watzmann** · 07-29-2009, 07:13 AM

thanks a lot , it works very well

**Phil_V** · 07-29-2009, 07:42 AM

Please remember to mark the thread as 'Solved'.
Edit your first post, click [Go Advanced], then use the drop down next to the subject to select [Solved]