New IFBLANK Function

[nouseforaname1982]

I have made the following function to return a referenced cell's value if there is one, but will leave the cell blank if there is nothing in the cell.

Can you think of any ways to improve this code? Add functionality to it? Maybe with some optional variables?

Post if you have suggestions.


Function IFBLANK(MyRange As Range) As Variant

If MyRange = "" Then IFBLANK = "" Else IFBLANK = MyRange

End Function

 

[Scott Huish]

This is very easy to do with native Excel functions, why the UDF?

=IF(A1="","",A1)

 

[nouseforaname1982]

This is very easy to do with native Excel functions, why the UDF?

=IF(A1="","",A1)

I am using it often and referencing the different sheets. So the "A2" in your formula is more complicated. its just a time saver right now but I may add some functionality to it.

My goal was to make it similar to the IFERROR function.