Add a third column containing the text in columns A and B.
"= A1 & B1" and fill down.
Do your search in the third column.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Lottery Numbers.xls in the free folder)
"SS" <(E-Mail Removed)>
wrote in message
news:f0daf10a-1c78-4dde-917b-(E-Mail Removed)...
> Hi,
> I want to run an operation, but, this may have already been done, so i
> need to notify user of that and not run again.
>
> Specifically:
> I need to search the 'Entry Log' sheet (columns A and B) for the word
> 'Enzyme' in column A, and a specific six digit number in column B (the
> number is already defined as variable req1). These two entries must
> be found adjascent to each other, in order for the find/match to be
> true.
>
> Example:
> req1 is currently 123456
>
> So, in order for my macro to continue, I want to search the sheet
> 'Entry Log' for the word 'Enzyme' in column A and 123456 in column B
> (adjascent). If it does not find, the macro continues. If it does
> find that match, say in range A26:B26, then a message to user appears
> that data has already been entered, etc... and then exits.
>
> Note: The Entry Log sheet Column A will have either the word Enzyme,
> or Strip, or Error. Column B will have many different six digit
> numbers.
>
> Thanks for any assistance,
> Steve
