| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting result of formula instead of actual formula
Couple of questions...
Is "worksheet" a worksheet object variable, a sheet code name or maybe a typo? Is the entry in cell A2 a working formula or could it be considered text by Excel? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "LoDawg" wrote in message 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting result of formula instead of actual formula
Sorry for the confusion. worksheet is an object variable, and the entry
in cell A2 is of the format: =(U16/54) + 6. Jim Cone wrote: Couple of questions... Is "worksheet" a worksheet object variable, a sheet code name or maybe a typo? Is the entry in cell A2 a working formula or could it be considered text by Excel? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "LoDawg" wrote in message 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. |
| Reply |
| 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 | |||
Linear Mode
