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