Application.WorksheetFunction.Index syntax

[LJones]

Novice, self-teaching VB user here...please help!

I am trying to do a simple For/Next Loop with an Index
Statement. I want to insert a text string from a range
names "List" into a cell, move 5 cells to the right,
insert the next name, etc.

I keep getting "Compile Error: Expected =" on the Index
Statement. What am I leaving out??
Thanks,LJ
---------------------

Range("A1").Select
For x = 1 To 3
Application.WorksheetFunction.Index(Range("List"),x,1)
ActiveCell.Offset(0,5).Select
Next x

 

[Vasant Nanavati]

ActiveCell = Application.WorksheetFunction.Index(Range("List"),x,1)

(although I would avoid all the selecting).

 

[keepITcool]

index is a function. thus is will produce a result.
you dont assign the produced result to a variable..
or a cell.. thus the error

change to Activecell.value =Application.Work...

and you s/b fine



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


LJones wrote :

 

[LJones]

Thanks! I feel kind of stupid for forgetting something
so simple.