| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if activecell is value
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if activecell is value
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if activecell is value
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if activecell is value
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if activecell is value
Dim r as range
Set r=ActiveCell if r.Value = 1 then... Set r=Range("Z100") if r.Value=1 then... -- Gary''s Student "רוז×*ט" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Name the ActiveCell | Excel Programming | |||
| activecell | Excel Programming | |||
| Activecell value | Excel Programming | |||
| how to set activecell? | Excel Programming | |||
Hybrid Mode
