VBA Vlookup formula not working

Hi

I have the following bit of code that is supposed to find all blank cells in a column, insert a vlookup formula and then if the formula returns 0, leave the cell blank, otherwise replace the formula with the found value.

When I type the vlookup code in manually in the same way, it works fine. When I insert it using this method, the vlookup doesn't find anything. Please could someone have a look and advise why it might not be working

Please Login or Register  to view this content.

Bump no response