View original (French)

Read the value of a cell

the_cube Posted messages 12 Status Membre -  
JvDo Posted messages 1924 Registration date   Status Membre Last intervention   -
Hello,
I would like to know the instruction that will allow me to read the value of a cell, knowing that this cell will have a value of 0 or 1.
Thank you

2 réponses

Réponse 1 / 2
JvDo Posted messages 1924 Registration date   Status Membre Last intervention   859
 
Hi,

to read the content of cell A1 from the active sheet, you can use 
ActiveSheet.Range("A1").Value
A+

(CELLS(1,1).Value works as well)
27