View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Need a property that will give me true if a value is close

Like should do it. For Example

If Activecell.Value Like "*Price*" Then
....

--

HTH

RP
(remove nothere from the email address if mailing direct)


"havocdragon" wrote in message
...
Ok so heres what im saying:

Lets say I have a value in a cell "Price"

If I put a value of "If activecell = "Price" then"

This will be a valid statement and do what I tell it to afterwards.

However,
lets say the value in the cell is " Price" or "$Price" how would I

make a
statment saying something to the effect of "If activecell = similar to
"Price" then"