Search for a non-value

[RRAnderson]

Hi,
First off thank you for all the help that many of you have given me. Many of my VBA questions have led me here.

I am hoping someone can give me an idea on how to do something in VBA. I have a column (S) that is usually filled with zeroes. However, sometimes another number will sneak in. I would like to be able to search the column for any non-zero values and if one is found, declare a boolean variable (named frt) TRUE. I am sorry I dont have any code, but I can't log on at work post it. If anyone has any suggestions, I would appreciate it.

Thanks!

 

[VoG]

Try

frt = WorksheetFunction.Max(Columns("S")) > 0