Recent

Author Topic: How to get the value of a cell that have a formula?  (Read 1556 times)

Jvan

  • Full Member
  • ***
  • Posts: 181
How to get the value of a cell that have a formula?
« on: April 17, 2021, 01:08:37 am »
How to get the value of a cell that have a formula?

Thanks.

wp

  • Hero Member
  • *****
  • Posts: 11858
Re: How to get the value of a cell that have a formula?
« Reply #1 on: April 17, 2021, 01:15:19 am »
You mean the calculated result? Add the workbook option boAutoCalc to calculate all formulas when a cell changes. Or call Workbook.CalcFormulas if you want to do it manually.

 

TinyPortal © 2005-2018