| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting result of formula instead of actual formula
I am working on a routine to send information from excel to a users
quickbooks company file. If the user has created a formula to calculate the value of a cell when the import routine sends it to quickbooks it sends the formula instead of the result of the formula. The line of code that pulls the information is formatted as follows: worksheet.range("A" & 2).value The quickbooks portion is working correctly when only values are entered. Thanks for any advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| How can I sort by the value of my formula and not actual formula | Excel Worksheet Functions | |||
Threaded Mode
