an easy one... but not for a beginner ("find" in a

[IgorDepecker]

tried hours and hours... the message board is the only solution left:
I should need a macro to find (ctrl-f) the data in f.i. cell A1 on sheet 1 somewhere on sheet 2... problem is that cell A1 on sheet 1 is not fixed (e.g. via a validation list);

Part of the macro that I'm stuck:
Cells.Find(What:="?", ...) can't define the data to look for where I put ? ...

thanks a lot for your help

 

[Yogi Anand]

Re: an easy one... but not for a beginner ("find"

tried hours and hours... the message board is the only solution left:
I should need a macro to find (ctrl-f) the data in f.i. cell A1 on sheet 1 somewhere on sheet 2... problem is that cell A1 on sheet 1 is not fixed (e.g. via a validation list);

Part of the macro that I'm stuck:
Cells.Find(What:="?", ...) can't define the data to look for where I put ? ...

thanks a lot for your help

Hi IgorDepecker:

Welcome to MrExcel Board!

If I understand you correctly, you should use ...

Cells.Find(What:=[Sheet1!A1], ...

I hope this helps!

 

[IgorDepecker]

Re: an easy one... but not for a beginner ("find"

tried hours and hours... the message board is the only solution left:
I should need a macro to find (ctrl-f) the data in f.i. cell A1 on sheet 1 somewhere on sheet 2... problem is that cell A1 on sheet 1 is not fixed (e.g. via a validation list);

Part of the macro that I'm stuck:
Cells.Find(What:="?", ...) can't define the data to look for where I put ? ...

thanks a lot for your help

Hi IgorDepecker:

Welcome to MrExcel Board!

If I understand you correctly, you should use ...

Cells.Find(What:=[Sheet1!A1], ...

I hope this helps!

Yogi Anand,
is indeed what I want to do, thanks for your reply but still doesn't work...
I am in cell A1 on sheet 2 and run the following macro:

Cells.Find(What:=[Sheet1!A1], After:=ActiveCell).Activate

 

[Yogi Anand]

Re: an easy one... but not for a beginner ("find"

Hi IgorDepecker:

Please post the entire code for your Sub and let us take it from there!

 

[IgorDepecker]

Re: an easy one... but not for a beginner ("find"

Hi IgorDepecker:

Please post the entire code for your Sub and let us take it from there!

Standing in cellA1 on sheet 2:

Sub Macro1()

Cells.Find(What:=[Sheet1!A1], After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate

End Sub

 

[Yogi Anand]

Re: an easy one... but not for a beginner ("find"

Hi IgorDepecker:

With the understanding that your DATA|Validation cell is cell A1 in Sheet1, your data is in the Active Worksheet Sheet2, the code works fine for me.

Please check your DATA|Validation setup -- and if you want to discuss this further , please provide details for your DATA|Validation for cell A1 in Sheet1.

 

[IgorDepecker]

Re: an easy one... but not for a beginner ("find"

Hi IgorDepecker:

With the understanding that your DATA|Validation cell is cell A1 in Sheet1, your data is in the Active Worksheet Sheet2, the code works fine for me.

Please check your DATA|Validation setup -- and if you want to discuss this further , please provide details for your DATA|Validation for cell A1 in Sheet1.

Thank you Yogi, it works