Case Sensetive =False

[fari1]

Sub newcode2()
startrow = 2
Sheets("statement").Select
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Sheets("sheet1").Select
sheet1rows = Cells(Rows.Count, "A").End(xlUp).Row
For Y = 1 To sheet1rows
   Sheets("sheet1").Select
   searchvalue = "*" & Cells(Y, "A").Value & "*"
   Sheets("statement").Select
   For X = lastrow To startrow Step -1
      If Cells(X, "A").Value Like searchvalue Then Cells(X, "A").EntireRow.Delete
   Next
Next
End Sub

hi, my above code is case sensetive, while i dont want it to be, any help plz

 

[fari1]

e.g if the search value is like this, "Case" then it wont delete those text which "case"
i want it to delete all the text irrespective of going into upper and lower case stuff

 

[jasonb75]

This looks like the same code that you're discussing with sagaar in http://www.mrexcel.com/forum/showthread.php?t=577533

Please read the forum rules that Joe4 directed you toward yesterday with regard to duplicate threads.

 

[VoG]

Duplicates

http://www.mrexcel.com/forum/showthread.php?t=577533

http://www.mrexcel.com/forum/showthread.php?t=577552

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).