Select range if values are visible after filtering

Good day,

I want to filter a table for values less than X

select the visible values and then delete them,

some times there are not any vlaues less than X, so I get an error when trying to select the visible values,

I want to create an if statement saying if there are no visible values skip this part (this is where I have dificulties),

Please let me know if there is a better way of writing this,

Please Login or Register  to view this content.

I couldn't duplicate your error, but I may not have understood. Perhaps something like this may help?

Please Login or Register  to view this content.

BTW what error were you getting.

thanks a lot for the response,

on error resume next will make it go to the next line of code or the next value in the for loop?

because after the delete it suppose to execute another task before going to the next value in the loop,

how can i check if there are no visible cells because I get a msg window saying there is an error because there are no visible cells,

since there are no visible cells, I cant set the value to visible cells,

upon adding an if statement, I get the same error, saying there are no visible cells in the table,

would i be easier to include the header and say if count of visible cells >1 ?

Please Login or Register  to view this content.

Error ...

Run-Time error '1004'
no cells were found

Did you try On Error Resume Next to see if it works for you? I again I couldn't duplicate your error, so I can't offer much more.