I am assigning a value to a variable from an oracle query using 0040
and a dynaset.

Eg For i = 1 To OraDynaSet.RecordCount
dbValue = OraDynaSet.Fields(0).Value
............................ bla bla


I am then trying to compare this variable with some value in a range
and am getting in all sorts of a mess with Exit For, End If :)

What I am trying to do is getting first record and compare to every
value in my range eg Range("A1:A3"). If it find a value then good and
we move onto next record. If it does not find a matching value then up
pops a msgbox and procedure stops. If all records from query are
matched in the range then naturally it also stops or does something
else without any problems


Thanks


--
mozart
------------------------------------------------------------------------
mozart's Profile: http://www.excelforum.com/member.php...o&userid=13314
View this thread: http://www.excelforum.com/showthread...hreadid=377019

if not (WorksheetFunction.Match(dbValue,range("A1:A3"),0) 0) then
msgbox "your message here"
exit sub
end if


Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37701