hello to all..
The above post...(hoping its in the right forum) refers to an Excel sheet with VB.
thanks again.
TK2
TK2
Last Activity: Oct 8 '07, 12:44 AM
Joined: Oct 7 '07
Location: The Boggie Down
-
How do I eliminate the Error msg although criteria is found?
hello group,
TK2 (New member)
Kindly look at the code below. It returns an error although the employee name is found. I'm stuck. Can someone help?
[CODE=vb]Sub EmployeeHours()
On Error GoTo errorHandler:
'************** *******
Dim Rng As Range
Set Rng = Range("j3:j528" ).Cells.Find(wh at:=InputBox("E nter Employee Name First"), _
LookAt:=xlWhole ,...Last edited by Killer42; Oct 8 '07, 01:40 AM.
No activity results to display
Leave a comment: