Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
.. 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 |
#3
|
|||
|
|||
... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
unmet challenge | Excel Worksheet Functions |