VLOOKUP Question (VBA)

[Andrew.Trevayne]

Hi all,
I'm scratching my head on the below codes.
It was working in one of my spreadsheet but when I try to apply it to the new one I am working on, it does not seem to work.
Any idea what I am doing wrong?

Please Login or Register  to view this content.

I wanted to see value on the target cells not formulas.
Any suggestions? Or perhaps better way of doing this?

Thanks in advance.

[jindon]

Change to

Please Login or Register  to view this content.

[jeffreybrown]

Try this...

Please Login or Register  to view this content.

[Andrew.Trevayne]

Thank you so much jindon! Always very helpful.