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!