tlchan
01-09-2013, 06:28 AM
Hi, I am stuck with copy entire row for the found value (X) in workbook(testbook.xls) to sheet("outputsummary") in Master summary.xls. Error as "runtime error 13, Type mismatch with error highlight at following
Set Rng = findrange.Find(What:=MyArr(I), _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Anybody can assist to complete the error?
Thanks
Set Rng = findrange.Find(What:=MyArr(I), _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Anybody can assist to complete the error?
Thanks