Greetings! I am new to this sub and decided to ask for some help after spending a couple of days screaming at the computer!

I am trying to do a loop for certain conditions.
I wish for said value on Cell C2 to be False. For each time that it is False, I wish to store or list the value in Cell R2 into a column and do this 1000 times until I have 1000 Values. I have tried doing a for loop but since I am fairly new to VBA I am having quite a bit of trouble. excel.PNG