VBA Vlookup row and column variables

[lethal]

I am trying to do a vlookup on my Excel spreadsheet using the following VBA code:

Please Login or Register  to view this content.

However when I run the macro the following formula ends up in cell J2 :

Please Login or Register  to view this content.

The formula is correct except for the apostrophes ' ' around o2.

How can I make it so there there are not any apostrophes around o2 so that it references the cell o2???

[rylo]

Hi

Can you please review the forum rules and make sure you wrap your code in future.

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

[lethal]

Hi

Can you please review the forum rules and make sure you wrap your code in future.

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

Ooops, sorry about that! I will remember for next time!

Your solution work perfectly! Thank you very much!!