Quote Originally Posted by snb View Post
Code:
Sub M_snb()
    [C7:C25000] = [if(B7:B25000>=A4,B7:B25000,"")]
End Sub
I really hate the square bracket notation. Anyway, that aside, your code returns a range of values to the worksheet which is different than what the OP's code suggested he wanted (you may be right in that being his ultimate goal, but he didn't say that and so I just wanted to point out that difference for his benefit).