Re: Omit rows to copy and paste if cell value does is not numeric
Hi All,
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
Code
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
Display More