[AccessD] Convert to Double - Excel OT

This is just a WAG, but assuming that data in columns 15 and 9 are the
integers, I'd do something like:

Cells(irow, 18).Value = getNPPTLCell(cdbl(.Cells(irow, 15).Value), _
  cdbl(.Cells(irow, 9).Value))

What does the function getNPPTLCell do?

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen
Sent: Monday, October 31, 2005 9:30 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Convert to Double - Excel OT


I need to convert a number that is an integer to double format, as my
routine is comparing an integer to a formula that contains decimals, and
naturally Excel is rounding up, causing my select statement to jump to
the next level of qualifications when any integer ends in the number 5.
Does anyone know where in the world I would put the CDbl() in this
statement:

    Cells(irow, 18).Value = getNPPTLCell(.Cells(irow, 15).Value,
.Cells(irow, 9).Value)

I have to define as rows as I am looping through the spreadsheet.  Happy
Halloween to all!

Karen S. Nicholson