No nbrs. will all ways be text as it is as describtion of entry
Thanks

"Bernie Deitrick" wrote:

Curt,

It depends on what your target values are. Are they strings that look like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

If Target.Column = 12 And CDbl(Target.Value) <= 0 And
IsText(Target.Value) Then _
Call Announcer(Target)


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks