Excel cannot read cell in VB code

Question:

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

if verificacel then

I'm not able to read the specific cell in the excel spreadsheet, in which I'm going to send the data to a database.

Answer:

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

verificaCel = x.ActiveCell.Value
Scroll to Top
AllEscort