Vlookup in LOOP

[mmmarks]

Hi Folks,

Can anyone look at below code I'm sure somewhere something is missing in code..
The code just pasting Vlookup funcion into the Cells, and results showing as #Name ?

All Advices are welcome & Thanks to everyone..

Please Login or Register  to view this content.

[Andrew-R]

If you're using a macro to put a formula into a cell then it needs to be a text string, with variable names outside of the quotes.

What you're after is probably:

Please Login or Register  to view this content.

[mmmarks]

If you're using a macro to put a formula into a cell then it needs to be a text string, with variable names outside of the quotes.

What you're after is probably:

Please Login or Register  to view this content.

Thanks Andrew.. It's works...