Hi Holger,
The user requires the 1+2 rather than the Type:=8 for the other worksheet because they have a huge amount of data that needs to stay in order, but only have a row deleted here and there without disturbing the rest of the worksheet.

Anyways, I need to keep it with the user entering rows to delete as (8,12,51,127,etc.)
I can't do the 8:8, 11:11, split method.
So I'm not quite sure how to adjust my code so they can't delete rows 1-7.
Thanks for your help.
I think I'll be pulling out my hair for a while with this one!

---------- Post added at 09:06 AM ---------- Previous post was at 08:57 AM ----------

Do you know of a way that I could search the string for the text or numbers "1,2,3,4,5,6,7" without it confusing it with 11,12,13, etc.

I saw that someone else had some code like this checking for specific text within a string. (See below)

Sub stringtest() 
    Dim str1 As String, str2 As String 
     
    str1 = InputBox("Enter something") 
    str2 = InputBox("Enter something else") 
     
    If InStr(1, str1, str2, vbTextCompare) Then 
        MsgBox "Match Found" 
    Else 
        MsgBox "No Match Found" 
    End If 
     
     
End Sub