Using WorksheetFunction.Index (Error)

[marreco]

Hi.
could someone help me fix this code so I put it to work?

Compile error:
Syntax Error

Please Login or Register  to view this content.

thank you

[shg]

We know everything except what you're trying to do ...

[marreco]

Hi.
I do intend to work returning the data in a worksheet named 'FIN'

[JieJenn]

.Range("A2:A" & LastRow).Application.WorksheetFunction.Index(BD!A2:B2000,MATCH(FIN!B2,BD!B2:B2000,0),1)

Maybe it should be .Range("A2:A" & lastrow) = "=index(BD!A2:B2000,worksheetfunction.Match(FIN!B2,BD!B2:B2000,0))"

[marreco]

Hi..

is not it!!

#Name?

[marreco]

Hi.

Any suggestion?

Thank you!!

[shg]

Yes, same as before: I suggest you explain in words, not code, what you're trying to do.

[marreco]

Hi shg

How will a database, then I will have many rows with formula.
this leaves my spreadsheet quite heavy and work hard.
to avoid this, I need the VBA do the calculation and not the Excel.Eu need to have the results in cells without becoming formulas.

[shg]

Do *what* calculation?

[marreco]

this would be the calculation that I need
Application.WorksheetFunction.Index(BD!A2:B2000,MATCH(FIN!B2,BD!B2:B2000,0),1)

[shg]

Please Login or Register  to view this content.

[marreco]

Hi.
correct it worked, now I need to drag it down according to the data from column 'B'

Thank you!!

[shg]

I don't know what that means. The formula is in col A.

[marreco]

Hi.
your code is doing what I need, but just need to drag the formula down and only later transformed into values​​.

[shg]

The code should enter the formula in all the cells down to the bottom of column B as it is.

[marreco]

Your code is fine, I just need to add a detail, if possible.

the code would put the formula in column 'A' (this is already done), then drag down (this does NOT done), then trasformaria in values ​​(this is already done).

Can you help me?

thank you!

[shg]

Ah.

Please Login or Register  to view this content.

[marreco]

Hi.

was wonderful, I'm very happy for helping me!
thank you very much!!