Excel Macro : Function to display blank when the formula evaluates to blank

Thamizh Bharat 0 Newbie Poster

13 Years Ago

Hi,

How do I write a VBA function to display blank if I want to refer to a blank value in pivot? Excel shows 0 in such cases. I don't want to handle this using

=IF(formula="","",formula)

since it involves repeating the formula twice.
Please let me know how i can write a user defined function for this. I am looking for a function like IFERROR say IFBLANK(formula,"") which accepts the formula and returns blank if the formula evaluates to "". Note: zero should be displayed only if the value in the pivot is 0.

Regards,
Bharat.

visual-basic-6

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

Pivot.zip (8.84 KB)

1 Contributor
0 Replies
55 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.