the code also iterates through hidden rows

[GrabberHackman]

"I don't understand why the code iterates through rows that aren't displayed, deleting the content within them. The logic of the code is such that if the loop encounters a hidden row, it should move on to the next row. The debug executed with F8 shows the steps correctly, but when I check the sheet, I find the content deleted."

Please Login or Register  to view this content.

[daboho]

Try change this line

Please Login or Register  to view this content.