Value in referenced cells

[snoopy80]

Good Morning!
I have an Excel file that has 2 sheets. Sheet1 is as follow
A B
-- --
1 Y
2 N

Now on Sheet2 I have exactly the same as Sheet1 because the cells A1, A2, B1, B2 (of sheet2)are just referenced from sheet1_that is A1 (of sheet2) =sheet1!A1 and A2=sheet1!A2 and B1=sheet1!B1 and B2=sheet1!B2. So I have in sheet 2:
A B
-- --
1 Y
2 N

Now my question is on Sheet1 this macro works:

Cells.Find(What:="m", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
End Sub

But when I try to run it on sheet 2 it does not work. I guess because the value of cells A1, A2, B1, B2 are not really 1, 2, Y, N. How can I make this macro to work on sheet2 where cells are reflecting from sheet1?
Appreciate your time and help.

 

[SkipVought]

Hi,

Lookin:=xlValues

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[snoopy80]

Thanks Skip!