Inserting function into worksheet via macro

[John mac]

I am trying to write macro that will loop through a worksheet active rows and
insert a "vlookup" function into col A that will look up based on value in
col b, somethng like:
For Row = last_row To 2 Step -1
asset_code = "B" & Row
Cells(Row, 1).Formula = "=VLOOKUP(""b""& row,Constants!A19:B55,2)"
Next Row
Warning.. I am a novice at macros and VB / VBA

 

[מיכ×ל (מיקי) ×בידן]

Follow, slowly, and try to understand the code in the attached picture:
http://img130.imageshack.us/img130/8758/nonames.png
Micky

 

[מיכ×ל (מיקי) ×בידן]

Sorry for the TYPO. Change the third line into:
For Row = LR To 2 Step -1
Micky

 

[מיכ×ל (מיקי) ×בידן]

Sorry for the TYPO. Change the third row into:
For Row = LR To 2 Step -1
Micky

 

[John mac]

Thanks Micky, it worked a treat (once I corrected all my typing mistakes that
is)