Copy cells value with or without formula

[lgomez]

Hello,

I'm copying the value of several cells of a sheet. Some of the cells have the a data and others contain a formula.
I can read the data with the method hoja.Range(i,j).value, and the data in the cells with a formula with the method hoja.Range(i,j).FormulaValue.

Is there any method that read both, the data of the cells with a data and the data of the cells with a formula inside?

Thanks,

Luis.

[Lisa.Li]

Hello,

Thanks for your inquiry.
You can use hoja.Range[i, j].DisplayedText to read the data for the both scenarios. If there is any question, please provide your testing file to help us further look into your issue. You could send it to us via email (support@e-iceblue.com).

Sincerely,
Lisa
E-iceblue support team

[lgomez]

Thank you!

[amy.zhao]

Hi,

You're welcome.
Feel free to contact us if you need any help.

Sincerely,
Amy
E-iceblue support team