Range("A1").Value = Int(Range("A1").Value) will round the value in A1 down to
the next lowest integer.

"Chris Gorham" wrote:

Hi,

I would like to use the funtion "rounddown" in some code that I'm writing.
The VBA help facility tells me that only "round" is available to me in VBA. I
believe that it is possible to import "rounddown" which is a function
available Excel s/sheet.

How do I do this...??

Thanks...Chris