Thread: INDEX functions problem
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_20_] Excelenator[_20_] is offline
external usenet poster
  
Posts: 1
Default INDEX functions problem

Replace the semi colons in your formula with commas.

Worksheets("Sheet1").Range("F2").Value = "INDEX(A1:E20*-,-*-4*-;-*-4)"

Nader Wrote:
Worksheets("Sheet1").Range("F2").Value = "INDEX(A1:E20;4;4)"



--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566629

Reply With QuoteReply With Quote