| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking activecell value for NA
I have this IF then statement:
If ActiveCell.text = "RED" Or ActiveCell.text = "GREEN" Or ActiveCell.text = "YELLOW" Or ActiveCell.text = "DONE" Then .... END IF What do I need to add to have it work if the activecell value is N/A? Thanks, Barb Reinhardt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking activecell value for NA
if activecell.text = "#N/A"
Barb Reinhardt wrote: I have this IF then statement: If ActiveCell.text = "RED" Or ActiveCell.text = "GREEN" Or ActiveCell.text = "YELLOW" Or ActiveCell.text = "DONE" Then ... END IF What do I need to add to have it work if the activecell value is N/A? Thanks, Barb Reinhardt -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking activecell value for NA
If application.isna(activecell.Value) Then
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Barb Reinhardt" wrote in message ... I have this IF then statement: If ActiveCell.text = "RED" Or ActiveCell.text = "GREEN" Or ActiveCell.text = "YELLOW" Or ActiveCell.text = "DONE" Then ... END IF What do I need to add to have it work if the activecell value is N/A? Thanks, Barb Reinhardt |
| 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) | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| if activecell is value | Excel Programming | |||
| IF ACTIVECELL contains | Excel Programming | |||
| Name the ActiveCell | Excel Programming | |||
Linear Mode
