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 ?
Error ...
Run-Time error '1004'
no cells were found
Bookmarks