How to return a value as an empty cell

**gone83** · 01-04-2011, 11:37 AM

Hello,

I have one question.

1. How to return a value as empty cell.

Please Login or Register  to view this content.

and I want this GPH return as empty cell.

Please Login or Register  to view this content.

Thanks guys!!!!

**DonkeyOte** · 01-04-2011, 11:53 AM

Perhaps you mean a Null, first change return type to Variant (from Double)

Please Login or Register  to view this content.

though given you don't appear to cater for any other ROT_type you might as well dispense with that Select Case altogether and just use:

Please Login or Register  to view this content.

**DonkeyOte** · 01-04-2011, 12:04 PM

FWIW, you might get away with:

Please Login or Register  to view this content.

Re: How to return a value as an empty cell