For Next Loop with IF statement inside does not loop

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)...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

instead of If Application.IsNA(ActiveCell.Value) Then.
The active cell is the one the cursor is in on the worksheet, not the one presently being looked at by the VBA code unless you "Select" or "Activate" which you don't usually have to do.

Untested

Please Login or Register  to view this content.

Hello roxybethany,

Welcome to the Forum!

I changed "ActiveCell" to the range variable "b" in the loop. It should work now.

Please Login or Register  to view this content.

Hello roxybethany,

YUou're welcome.