Run-Time Error 424

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
... just a guess, but

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

could this mean that your ActiveCell is in column A or B ?
 
.... 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXIT SUB UPON VBCANCEL 2
If statement in macro 2
Display Recipients With Todays Birthday 0
VBA - Do Loop or SaveChanges = false 1
Run time error 424 0
Application-defined or object-defined error Please Help 1
Macro from older version into Office 2013 on Windows 8 3
Macro - Vlookup 6

Back
Top