Hi,
I guess this is quite simple but I can't get it.
How do I Loop a macro to row 1000?
I have: Loop Until ActiveCell = vbNullString
But as I have empty cells every now and then the macro stops.
I want the loop to go all the way to row 1000
like Loop Until Row=1000
But how do I write so excel understand what I want?
I guess this is quite simple but I can't get it.
How do I Loop a macro to row 1000?
I have: Loop Until ActiveCell = vbNullString
But as I have empty cells every now and then the macro stops.
I want the loop to go all the way to row 1000
like Loop Until Row=1000
But how do I write so excel understand what I want?