Excel can not read cell in VB code

3
x.Range("A1:z1").Select
x.Goto Reference:="R2C4"
verificaCel =     x.ActiveCell.FormulaR1C1

if verificacel then

I am not able to read the specific cell in the excel sheet, in which I will send the data to a database.

    
asked by anonymous 04.10.2017 / 14:24

1 answer

1

To read the cell value, you must use .value or .text if applicable. Using .FormulaR1C1 the result will be the cell formula. Here is the correction below:

verificaCel = x.ActiveCell.Value
    
04.10.2017 / 17:00