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.
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.
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