I am working on a project (that should be simple) but I cannot get it to work. All I need it to do is to loop through a range of cells that will always start in cell D2 but will have a different ending row count every week and look for any cell that shows #N/A (from a previous vlookup formula) - then show an input box, we input the correct ID# which gets put into the cell instead, and move onto the next cell until there are no more cells. I have tried various ways of doing this and the inputbox part works (i.e. if I have #N/A in the first cell it completes what I want it to do) but it never moves on to the other cells.... please help! Here is my code at the moment (this is just an excerpt so I copied all my variable declarations even what I don't use)...
Bookmarks