This is the only one.
As items get deleted this #REF! Is then shown.
Let’s say it was looking for data in cell Z50 but then I delete Z50 this is when it appears.
If I look either side of this row I see code for Z49 in the row before and Z50 in the row after so this row which has the #REF! In is then redundant and isn’t needed or upsetting the code.
Hence why I would like it gone.
Ive put the code with another in the This workbook as shown below.
When i open the workbook i get a pop up message saying No cells found ?
Having said that is it best if i put the code back as it was and have the code run each time the worksheet is open,if so please advise.
Private Sub Workbook_Open()With Worksheets("HONDA SHEET")
ActiveWindow.ScrollRow = 13
With Worksheets("INV DETAILS")