Find in another sheet
 

Hi All,

How can I use find in a defined range in another sheet using VBA?

for Eg. If I run my code from sheet1 and without activaing sheet2 I
want to search for a word within range "MyRange"

Thanks

Find in another sheet
 

try this idea that will find it from anywhere in the workbook.

Sub findinnamedrange()
MsgBox Range("MyRange").Find("whatever").Address
End Sub
--
Don Guillett
SalesAid Software

"Soniya" wrote in message
ups.com...
Hi All,

How can I use find in a defined range in another sheet using VBA?

for Eg. If I run my code from sheet1 and without activaing sheet2 I
want to search for a word within range "MyRange"

Thanks