Run-Time Error 424
 

Hello,

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

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

.. just a guess, but

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

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



Jeff Wrote:
Hello,

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

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=473897

... 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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=473897