Re: Omit rows to copy and paste if cell value does is not numeric
I have since written the code below (part of the full code), and it seems to work fine on my excel. However, when run on some other PCs, it produces an 424 error 'object required' at the line in red below.
does anyone have any idea what's wrong with the code? Basically I am trying to hide the entire row if column 16 of the table contains an error.
'identify the columns and copy the data
With Worksheets("ABC").ListObjects(1).DataBodyRange .EntireRow.Hidden = False On Error Resume Next Set MyRange = .Columns(16).SpecialCells(xlCellTypeFormulas, 16).EntireRow On Error GoTo 0 If Not MyRange Is Nothing Then ' this line MyRange.EntireRow.Hidden = True End If Set MyRange = Nothing