LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default return the value of cells and not the formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
compare 2 column cells and return the adjacent columns cells data of the cell trebor57 Excel Worksheet Functions 1 February 1st 11 02:54 PM
Search range of cells for word & return value for use in formula? Peter Psych Teacher Excel Worksheet Functions 2 October 19th 08 11:25 PM
Formula to return the reference of a range of cells tiptoe Excel Discussion (Misc queries) 4 February 16th 08 11:28 PM
EXCEL FORMULA RETURN X IF VALUE IN 4 CELLS HAS VALUE RERAA Excel Worksheet Functions 3 August 10th 05 10:12 PM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"