Find [VALUE] then store True/False

**rziegler** · 08-03-2009, 01:18 PM

I want to search the active worksheet for the words "dunnage", "dun", and "dunn" and if any one of those values are present I'd like a variable (Dun) set to "true". If not present, then set to "false". I can't figure out the script to do this.

public variable name: Dun

Probably a simple request for a guru out there.

Thanks!

**seckert** · 08-03-2009, 04:51 PM

Create a cell with the range name "CheckDun" a a formula '=countif[range to search],"*dun")

Code: if range("CheckDun").Value > = 0 then
then true else false