IF-Then-Else loop stopping and producing runtime error 1004

Optiprime,

Welcome to the forum!
The issue is that you need to set if the Bold is True or False, so change the line to:

Please Login or Register  to view this content.

As for using a placeholder, you could simply have a blank line.

Instead of that though, look for the opposite. In other words, instead of looking for "Y" and only deleting rows that don't match, look for <> "Y" (does not equal "Y") and only delete rows that match, like so:

Please Login or Register  to view this content.

need a sample file, your code works on my test sheet

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save