Run-Time Error 424

J

Jeff

Hello,

I have an error msg: Run-Time Error 424 on this VBA procedure:

If ActiveCell.Value = "SP" Then
Set CellWithValueToMatch = ActiveCell.Offset(0, -2).Value
 
B

Bryan Hessey

... just a guess, but

Range("A1").Value = Error(424) shows 'Object required'

could this mean that your ActiveCell is in column A or B ?
 
B

Bryan Hessey

.... just a guess, but

Range("A1").Value = Error(424) shows 'Object required'

could this mean that your ActiveCell is in column A or B ?



SECOND guess (after testing) is to try removing the word 'Set' and use

CellWithValueToMatch = ActiveCell.Offset(0, -2).Value
 
Top