VBA - index cell in selection - worksheetfunction.index(selection,cell)

[i_excel]

Hi

The following code doesn't work

Sub Index()
Dim Cell as Range
For Each Cell In Selection
    MsgBox WorksheetFunction.Index(Selection, Cell)
Next Cell

Does anyone know why that is?

Any help would be greatly appreciated.

i_excel

 

[Joe4]

What exactly are you trying to accomplish?

Also, NEVER use reserved words (i.e. names of functions, properties, objects, methods) for the name of variables or procedures!
You named your procedure INDEX.
So now whenever you use INDEX in your code, Excel might get confused, not sure if you are referring to the native INDEX function or your custom INDEX procedure. This can let to unexpected behavior.

Always use unique names. I often preface with "My", i.e. Sub MyIndex()