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]

Hi
how is i defined?

--
Regards
Frank Kabel
Frankfurt, Germany

"crombey" schrieb im Newsbeitrag
...
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]

i is defined as integer (it's index)

nom=cells(4,12)
if the content of cells(4,12) is a formula i would like to have the
value of the formula ("bonjour" for instance)

i have tried
nom=cells(4,12).value
i have tried
nom=cells(4,12).values
i have tried
nom=cells(4.12).value2
I think i don't use the whright syntax


Thank you for your help
please answer to email

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi
normally the following should work:

sub foo()
dim nom
nom=activesheet.cells(4,12).value
msgbox nom
end sub


--
Regards
Frank Kabel
Frankfurt, Germany


crombey alain wrote:
i is defined as integer (it's index)

nom=cells(4,12)
if the content of cells(4,12) is a formula i would like to have the
value of the formula ("bonjour" for instance)

i have tried
nom=cells(4,12).value
i have tried
nom=cells(4,12).values
i have tried
nom=cells(4.12).value2
I think i don't use the whright syntax


Thank you for your help
please answer to email

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!