Thus far, when I want to loop something I just set the loop to be greater than what I need it to be. 

For i = 1 to 5000

if cells(i,1).value=5 then
cells(i,1).interior.color = 1
end if

next
But then I have to wait while the macro checks alot of empty cells below where I have the data. I know I could use 

Do while activecell.value<> empty
loop
But could I do something similar to this??

For i = 1 to Columns("A").count

Next