or without worksheet formulae

myVar = (2.1+1)*10\10

--

HTH

Bob Phillips

"LSB" wrote in message
...
I would like to use this function in my macro. As I found
this function in the Excel Help, but when I use it in
thecoding it prompts me the error message 'Sub or Function
not Defined'. I would like to know how can I work on this
error.
Actually I want to round up my figure, for example

2.1 roundup to 3
3.5 roundup to 4
6.9 roundup to 7

Ccan please somebody help me on this. Thanks in advance.