Hi Nader,

Use

Worksheets("Sheet1").Range("F2").FormulaLocal = "INDEX(A1:E20;4;4)

Or use commas instead of semicolons, then you can use .Formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Nader" wrote in message ...
| Hello,
|
| I'm trying to use the INDEX fonction in vba and I keeping getting errors.
| Here's an example :
|
| Worksheets("Sheet1").Range("F2").Value = "INDEX(A1:E20;4;4)
|
| or
|
| Worksheets("Sheet1").Range("F2").Formula = "INDEX(A1:E20;4;4)
|
| When running one of these codes, I get this error :
|
| Run-time error 1004
| Application-defined or object-defined error
|
|
| What should I do to make it work ?
|
| thanks in advance.
|
| Nader
|
|