If you are using VBA try something like this


With Sheets("Template")

Set MyRange = .Range("C17:C1016")
Set c = MyRange.Find(what:="*", _
searchdirection:=xlPrevious, _
LookIn:=xlValues, lookat:=xlPart)
If Not c Is Nothing Then
Results = "EXP_" & Sheets("Start Here").Range("D" & c.Row)
End If
End With



The find method using the wildcard * and the searchdirection xlPrevious
will do what you want.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197450

http://www.thecodecage.com/forumz