Vlookup works fine, but not in Macro

[jomili]

I'm trying to use the macro below to paste a Vlookup formula into my spreadsheet. When I run the macro, the results are all FALSE. However, if I pull out the Vlookup formula itself and apply it into the cells (in columns J and K), changing RC[9] or RC[10] to A2, it works perfectly. What am I doing wrong? I've been fooling with this for hours, and it seems so simple, but I'm not seeing it. Please help.

Please Login or Register  to view this content.

[shg]

Not

Please Login or Register  to view this content.

just

Please Login or Register  to view this content.

[jomili]

Well, I guess if I'm going to look stupid, I should look REALLY stupid. I can't believe I did that, AND didn't see it. Thanks for setting me straight!