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.