I seem to be having problems in the worksheet change event when I have non-contiguous rows in the target object.
Once I select the non-contiguous rows I press the delete key. The change event checks if all the cells in the target row are blank. If so, hide that row. If not do not hide it but check the next row in the target until all the rows are checked.
The following code works for one row but doesn