<div>
Hi,<br />
<br />
Have you verified in the VBE Options/ General &nbsp;your Error Trapping Status<br />
<br />
Break on All errors OR Break in Class Module OR Break on Unhandled Errors ( the right one)<br />
<br />
Regards
</div>


Hi,

Have you verified in the VBE Options/ General  your Error Trapping Status

Break on All errors OR Break in Class Module OR Break on Unhandled Errors ( the right one)

Regards

<div>
Hello,<br />
<br />
My Error Trapping Status appears to be set to Break on Unhandled Errors...<br />
<br />
Is this correct? &nbsp;On this setting the problem does however persist :(
</div>


Hello,

My Error Trapping Status appears to be set to Break on Unhandled Errors...

Is this correct?  On this setting the problem does however persist :(

<div>
<div class="content wysiwyg-content">
Hello <br />
<br />
I am struggling with my error handling in VBA (please refer below for an extract of code).<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;Worksheet.Cells.Select<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;On Error GoTo NoPrecedentCells<br />
&nbsp; &nbsp; &nbsp; &nbsp;Selection.DirectPrecedents<wbr />.Select<br />
<br />
NoPrecedentCells:<br />
<br />
End Sub<br />
<br />
Regardless of the &quot;On Error&quot; command, a run-time error 1004 (No cells were found) arises.<br />
<br />
Can you assist in anyway.<br />
<br />
Thanks and regards<br />
Aidan
</div>
</div>


Hello 

I am struggling with my error handling in VBA (please refer below for an extract of code).

       Worksheet.Cells.Select

       On Error GoTo NoPrecedentCells
       Selection.DirectPrecedents.Select

NoPrecedentCells:

End Sub

Regardless of the "On Error" command, a run-time error 1004 (No cells were found) arises.

Can you assist in anyway.

Thanks and regards
Aidan

Run time error on DirectPrecedents.Select

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.