in reply to Get Cell Value while Reading Excel file and not the formula

You need to provide some context if you expect an answer. For example, which modules are you using, how does the code look like writing into the cell, reading from the cell etc.

In Excel, the formula bar always shows the formula in the cell and not the value. I assume, that is where it's name coming from. At least, if there is a formula in the cell.

  • Comment on Re: Get Cell Value while Reading Excel file and not the formula