Trying to build UDF but failed

[YasserKhalil]

Hello
I'm trying to build UDF Function

Please Login or Register  to view this content.

I'm trying to let the function look at the value of the cell .. If it is an integer the result will be the same
But if it is not an integer the result should be integer by using the Ceiling Function

[Crooza]

I don't do much in UDF but at a complete guess have you tried to change your
'x = '
To
'X.value="

[HaHoBe]

Hi, YasserKhalil,

using an UDF you canīt change the value of any other cell than the one who calls the function. And you should use the name of the Function to return the result.

Please Login or Register  to view this content.

Ciao,
Holger

[YasserKhalil]

Thank you very much for this perfect swift solution

I'm still learning .. And here in this great forum I'm learning a lot

[YasserKhalil]

Just a nother point
What if I want to deal with the numbers directly
=SpecialCeiling(119.99)
I have a value error

I want the function to be flexible : deal with ranges of numbers (integers and decimals of course) and deal with these numbers directly

[YasserKhalil]

I want the function to be flexible : deal with ranges of numbers (integers and decimals of course) and deal with these numbers directly
is it possible or not?

[HaHoBe]

Hi, YasserKhalil,

you started giving the parameter a certain type of object: a range. If you want to be more flexible you should alter that maybe as follows:

Please Login or Register  to view this content.

Ciao,
Holger

[YasserKhalil]

Thanks again for this great solutions
I appreciate your help