Find method using User input
 

I have the user enter the string they need to find, and then i run
find to find it.


Code
-------------------

Public Sub Clean(Manu As String)
Dim FinalRow as Long
FinalRow = Range("I65536").End(xlUp).Row
If Len(Manu) 0 Then
With Range("A1", "I" & FinalRow)
.Select
.Sort Range("D1"), xlAscending, Range("E1")
.Find Manu
End With
End If

-------------------


For some reason that doesn't want to allow me to search. One of th
things im trying to search for is Steel. So I run this, manu get
Steel, and nothing. So I do a find from within Excel and search fo
Steel and it works.

Does VBA give excel the string in ""s or is something else happening?
I have been trying to work around this for quite a while now and i can
get anythign to work.

Thanks for the help
Cor

--
Message posted from http://www.ExcelForum.com

Find method using User input
 

Well i figured it out myself. I realized that i forgot to do
.Activate after the find statement so even though it found it, I di
not see it.

Sorry for the wasted pos

--
Message posted from http://www.ExcelForum.com