I have written a small and simple macro to take values from a
spreadsheet and email them. When I run the macro against the
spreasheet everything works fine unless there is a value in the cell
that is not a whole number. i.e. 4.5 When the macro collects the value
it rounds it down to a 4 instead of holding the value of 4.5. Can
anyone tell me why it does this and how I can stop it?

Hi Greg,

How have you dimmed the variable that holds the value?

If you have dimmed the variable as long or integer, the results you describe
would occur.

If this is the case, change the variable to double.

Otherwise, post the problematic code.

Incidentally, this would appear an Excel problem rather than an Outlook
problem and might, therefore, have been more effective had you posted it in
(say) the Excel.Programming NG.


---
Regards,
Norman



"Greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have written a small and simple macro to take values from a
> spreadsheet and email them. When I run the macro against the
> spreasheet everything works fine unless there is a value in the cell
> that is not a whole number. i.e. 4.5 When the macro collects the value
> it rounds it down to a 4 instead of holding the value of 4.5. Can
> anyone tell me why it does this and how I can stop it?
>