I need some help.
I have a number being input in Sheet1, which I have to find in rest
of the worksheets.
I am recording a macro for this.For recording I do Ctrl+F, and type
in the input number in "Find What" textbox. The other settings of
the Find box are:
Within: Workbook
Search : By Rows
Look in : Values
Mach enitre cell contents

Obviously , the first time I hit "Find Next", I stay in the same
sheet and the cell highlighted is the same as the cell in which
input is being done. Therefore, I have to hit "Find Next" again to
reach the first occurance of this number in the rest of the
worksheets.
The macro generates the following snippet:

Sheets("Sheet1").Select
var_no = Range("A3").Value
Cells.Find(What:=var_no, After:=ActiveCell, LookIn:=xlValues,
LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
True, SearchFormat:=False).Activate
Sheets("Sheet2").Select
Cells.FindNext(After:=ActiveCell).Activate)

In this case, the input number was lying in Sheet2

Now, what I want is simply, the name of the sheet (Sheet2 in this
case) where the first occurance of that number is, to be captured in
some variable (say, var_SheetName).