Replace the semi colon in your formula with a comma.

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