Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match)
2003, 2007
Have a routine where I would like to ascertain if myCell,value = an array of myCell2 cells. What I conceive the formula to be is: VBA Message = IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match) Another way to phrase my question. 1) I have an array of myCell2 Formulas on Secondary W/S 2) Also I have an array of myCell Formulas Secondary W/S 3) TempFormula is a string representing the formula on the Master Worksheet 4) If myCell.formula matches any of the myCell2.Formula(s) then I want to: 5) Replace(TempFormula, myCell2.value,"") 6) How can I write an array(?) formula to have all of the array values available for the replace test? TIA EagleOne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match)
How is myCell2 Dim'med and how did you assign values to it?
-- Rick (MVP - Excel) wrote in message ... 2003, 2007 Have a routine where I would like to ascertain if myCell,value = an array of myCell2 cells. What I conceive the formula to be is: VBA Message = IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match) Another way to phrase my question. 1) I have an array of myCell2 Formulas on Secondary W/S 2) Also I have an array of myCell Formulas Secondary W/S 3) TempFormula is a string representing the formula on the Master Worksheet 4) If myCell.formula matches any of the myCell2.Formula(s) then I want to: 5) Replace(TempFormula, myCell2.value,"") 6) How can I write an array(?) formula to have all of the array values available for the replace test? TIA EagleOne |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match)
Hi Rick,
MyCell, MyCell2, MyRange & Myrange2 are all Dim'd As Range EagleOne "Rick Rothstein" wrote: How is myCell2 Dim'med and how did you assign values to it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Custom Data Validation : Lock if MyCell = ""? | Excel Worksheet Functions | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Application.Goto reference:="MyCell" | Excel Programming |