I have wriiten a macro, in which I execute a vlookup. It works fine while I am recording the macro but when I execute it I am given #N/A errors. Before stopping the recorder I copied - paste - value so it would not need the vlookup formula. Then I moved and hid the columns the database and column 1 were in.
Here is the code below.
Please Login or Register to view this content.
Bookmarks