Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
in cells(1,5) there is a formula [=Recherche(A4;B5:B15;C5:C15)]whitch ha
s a string value "bonjour" sub() nom(10) as string nom(i)= cells(1,5) end sub The sub fails and doesn't return the value "bonjour" I use nom(i) to sort values later in the programm I have tried to use nom(i)= cells(1.5).value but I fail because it's a string variable Thanks to help me =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Article poste via Voila News - http://www.news.voila.fr Le : Wed May 26 22:37:26 2004 depuis l'IP : 80.8.64.103 [VIP 381397376091] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Search range of cells for word & return value for use in formula? | Excel Worksheet Functions | |||
Formula to return the reference of a range of cells | Excel Discussion (Misc queries) | |||
EXCEL FORMULA RETURN X IF VALUE IN 4 CELLS HAS VALUE | Excel Worksheet Functions |