Right now I'm looping through the sorted column and marking the
beginning row and end row of a column having a specific value and
selecting that.

But does Excel have a mechanism that does this for you?

Or perhaps, instead of selecting the rows, selects all the values in
one column having a specific value?

Even better yet would be a solution where the rows can then be deleted.

Thanks.