Thread: If Error condition with Match Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T De Villiers[_77_] T De Villiers[_77_] is offline
external usenet poster
  
Posts: 1
Default If Error condition with Match Function

Hi, Can do the match function, but need a condition so that if there i
an
error returns 0, with below not returning anything (I have 'On erro
Resume Next' at top of code)

Cells(2, 10) = WorksheetFunction.Match(Cells(2, 9), Range(Cells(2, 8)
Cells(10, 8)), 0

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=56659

Reply With QuoteReply With Quote