View original (French)

Read the value of a cell

the_cube Posted messages 12 Status Member -  
JvDo Posted messages 1924 Registration date   Status Member 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 answers

  1.
    JvDo Posted messages 1924 Registration date   Status Member 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