I am trying to find the #1 in a column and perform a specific function if the active cell = 1 (it also deletes the entire row where there is the #1) for an entire column (called "temp"). I am then continuing to find the #1 by looping until active cell = blank.
The issue I have is that when all #1's have been deleted, in the temp column, I receive a macro error as it can't find the #1 anymore.
How do I resolve this error?
The issue I have is that when all #1's have been deleted, in the temp column, I receive a macro error as it can't find the #1 anymore.
How do I resolve this error?
| |||||||||||||||||||||||||||||||||||||||||