User-defined function to give blank cell?

[wal]

Excel 2003

I have a spreadsheet function that looks something like this:

=IF(OR(RangeA=0,RangeA=""),"",IF(RangeA-15000<=0,"",RangeA-15000))

I need to add more conditions, so I'm trying to write a user-defined
VBA function. What code (if any) can be included in such a function
to get the first result shown above, i.e., a blank cell (symbolized by
"" in a worksheet function) under certain conditions?

Thanks.

 

[Tim Zych]

Same as a worksheet function, a zero-length string ("") although some
developers use vbNullString. They are slightly different internally but for
your purposes they should be functionally similar.

Rob Bovey explains the difference:
http://www.dailydoseofexcel.com/archives/2008/06/26/identify-empty-cells-in-vba/

And a little more info:
XL2000: How to Use Visual Basic Constants in Text Strings
http://support.microsoft.com/kb/211774/en-us