Remove data when checkbox is unchecked

Good day all once again,

I have a Userform with a series of checkboxes, when a box is checked it then populates "Page4+" with the requested range, however when unchecked this information needs to be removed from "Page4+",
I have a code below that used to work but for some reason no longer removes the data when unchecked...any help as always would be greatly appreciated, thank you all & have a great day - Marco

Please Login or Register  to view this content.

The code is looking for "UNLOAD WITH CRANE" and apparently not finding it. Did you change the text within the source Sheets("Test").Range("Crane")? Perhaps not all upper case anymore?

This will look for any case text
Set rngFND = .Cells.Find("UNLOAD WITH CRANE", LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=False)

Hi AlphaFrog,
I've checked every range & title but all are correct, I've attached a sample of my spread sheet if this helps? Thanks again - Marco

I have Excel 2003 and it errors when opening your file. Sorry. I have no new ideas.

BTW: you don't need the On Error Resume Next line in your procedure.

hi matrixprom, the reason is your sheet is protected so you need to unprotect it, delete rows and protect again.