Omit rows to copy and paste if cell value does is not numeric

Hi,

i have an existing code that copies and pastes filtered visible cells from one table (in sheet 1) to another (in sheet 2).

however, I would like to add in a criteria such that if the column Q value is not numeric (I.e which is a result of the formula returning an error), then that particular row will be omitted from the copy/paste.

How can I incorporate this criteria into my vba?

Thanks!
Clariinc

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

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