I coded exactly what yuo asked for. Can't guarentee it will work.

If (cell.offset(0,2).value< Worksheets(cell.value).Range("A1").End(xlDown)
_
or (cell.offset(0,1) .value= "EQ") _
or (cell.offset(0,1) .value= "BE") Then

"TUNGANA KURMA RAJU" wrote:

I am not an expert in Vba code.I have a line code
If cell.offset(0,2).value< _
Worksheets(cell.value).Range("A1").End(xlDown) Then
Set Sh1=nothing
I would like to add one more condition to the above line,apart from the
above condition, If cell.offset(0,1) .value= "EQ" or "BE".How to modify my
line code ?
If my coditions are not met ,the sub should exit by prompting message
"Conditions are not met,Updation not required" with one "ok" button.Where
this message code line has to incorporate.Thanks whole community in advance.