If Activesheet.Range("B2").Value =
Workbooks("other.xls").Worksheets("Sheet1").Range( "H2") Then
Msgbox "Value exists"
End if

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TUNGANA KURMA RAJU" wrote in
message ...
Looking for a simple code for:
If this worksheet $b$2 value=other w/book sheet1 $h$2 value
then msg"value exists" and exit sub() ,if not do something else.(both
w/books are in same folder)