if application.isnumber(activecell.value) then



if application.isNumber(Range("B9").value) then


--
Regards,
Tom Ogilvy



"רוז×*ט" wrote:

i mean contains value like 900 , 1 , 5.5....
not textualy cell or formula

not equals to...

what is the meaning of "ABC"
is it an example or some constant or what?

rozent

"Bob Umlas" wrote:

If Activecell.Value = "ABC" Then...
but if you really mean CONTAINS, as opposed to EQUALS:
If Instr(Activecell.Value,"ABC")0 Then...

FOr 2nd part, replace "ActiveCell" with something like Range("E6"):

If Range("E6").Value = "ABC" Then...

Bob Umlas
Excel MVP

"?????" wrote in message
...
what is the macro to identify if the activecell contains value
and what is the macro to identify if cell XX contains value

thank you
rozent