Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if value exists
hi,
I am trying write code to determine if a specific value, lets say "DOODLE" exists within a specified range in an excel sheet. The range specified could be J12:J88 for example. Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if value exists
With Code or a function?
code: Dim SearchCell As Range Set SearchCell = Range("J12:J88").Find(What:="DOODLE",LookAt:=xlWho le) If SearchCell Is Nothing Then MsgBox "DOODLE Does Not Exist in Range J12:J88" End If Function: If(Iserror(Match("DOODLE",J12:J88,0)),"Not There","Found At: J" & (Row() - 1 + Match("DOODLE",J12:J88,0)) HTH Charles Chickering geebee wrote: hi, I am trying write code to determine if a specific value, lets say "DOODLE" exists within a specified range in an excel sheet. The range specified could be J12:J88 for example. Thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if value exists
If Not IsError(Application.Match("DOODLE",Range("J12:J88" ),0)) Then
'value found Else 'value is not found End If -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "geebee" wrote in message ... hi, I am trying write code to determine if a specific value, lets say "DOODLE" exists within a specified range in an excel sheet. The range specified could be J12:J88 for example. Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA:: determine if UDF exists? | Excel Discussion (Misc queries) | |||
Determine if a File Exists | Excel Discussion (Misc queries) | |||
Determine if Named Range exists in Worksheet | Excel Programming | |||
Determine if folder exists | Excel Programming | |||
Determine if Value in column A exists in Column B | Excel Discussion (Misc queries) |