Function returns #VALUE

[sprites]

Hey,

I'm trying to have a simple function to return blank ("") on some condition, and I just can't get rid of it returning #VALUE no matter what.. what am I missing?

Please Login or Register  to view this content.

Note: 1. "default_alt" is global. 2. It works fine except for the ELSE part. 3. Doesnt matter if I change the type of the function from Variant to anything else.

Thanks

[romperstomper]

Your tests for IsNumeric and IsEmpty are pointless - you have declared the function in such a way that it will only accept integer values as inputs - if you pass anything else it will simply error.

[sprites]

Just like you said.. fixed it, thanks