Quick VBA question

[iisailor]

I have this line of code in my macro and it continues to cause the error of method Range of object '_Global' failed.
im simply wondering if it has anything to do with my use of AND. This may sound stupid but ive never used AND in this way before so just wanted to double check.
Thanks in advance
Chris

If Range("B" & CStr(StockSearch)).Value = Range("A" & CStr(CopiedParts)) And Range("C" & CStr(StockSearch)).Value = Range("B" & CStr(CopiedParts)) And Range("D" & CStr(StockSearch)) = Range("C" & CStr(CopiedParts)) Then

 

[Richard Schollar]

Very difficult to tell without seeing how StockSearch and CopiedParts are defined and assigned values. The syntax looks OK and will pick up ranges from the currently Activesheet.

 

[xld]

This should work

If Range("B" & StockSearch).Value = Range("A" & CopiedParts).Value And _
    Range("C" & StockSearch).Value = Range("B" & CopiedParts).Value And _
    Range("D" & StockSearch).Value = Range("C" & CopiedParts).Value Then

as long as none of those variables are not zero