Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does a HasDependents = True property exist? | Excel Discussion (Misc queries) | |||
how excel calculates the major units on an axis when MajorUnitIsAuto property set to true | Charts and Charting in Excel | |||
how excel calculates the major units on an axis when MajorUnitIsAuto property set to true | Charts and Charting in Excel | |||
how to set pivotitem.visible property to true | Excel Programming | |||
How can I set PivotItem.Visible property to True? | Excel Programming |