compare a value in two w/books
 

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)

compare a value in two w/books
 

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)

compare a value in two w/books
 

Thanks ,but it is not working,compile error:expected expression error is
coming.What to do ?

"Bob Phillips" wrote:

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)

compare a value in two w/books
 

Probably just NG wrap-around

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 ...
Thanks ,but it is not working,compile error:expected expression error is
coming.What to do ?

"Bob Phillips" wrote:

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)

compare a value in two w/books
 

Same error coming !

"Bob Phillips" wrote:

Probably just NG wrap-around

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 ...
Thanks ,but it is not working,compile error:expected expression error is
coming.What to do ?

"Bob Phillips" wrote:

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)