Is there a way i can get cells to automatically hide when the formula returns a zero value.
I would need the cell to automatically unhide if the formula then returned an actual value?
Thanks
Is there a way i can get cells to automatically hide when the formula returns a zero value.
I would need the cell to automatically unhide if the formula then returned an actual value?
Thanks
if by "hide" you mean...not show anything, then try this....
=if(your-formula=0,"",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
See your other post
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
@ Mod Team - can you close this thread, please - OP is continuing here: http://www.excelforum.com/excel-form...40#post3295940
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
OK thanks BB
THREAD CLOSED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks