LinkBack URL
About LinkBacks
Hi i would like my sheet to hide cells where a formula returns a zero value.. But i also need it to unhide should the formula later return an actual value
it would need to apply from a10-i10, then continue downwards to the end of the sheet
thanks
Hi i would like my sheet to hide cells where a formula returns a zero value.. But i also need it to unhide should the formula later return an actual value
it would need to apply from a10-i10, then continue downwards to the end of the sheet
thanks
DUPLICATE POST. Original is here: http://www.excelforum.com/excel-form...ero-value.html
Shan1monkey, please do not duplicate posts - not only is it against the forum rules, it can result in volunteers wasting their time answering a question that has already been answered.
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.
You can use a custom number format to do that.
Select the range of cells in question
Right click>Format Cells>Number tab>Custom
Enter this code in that little box under "Type:"...
[=0]"";General
OK out
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I dont think i explained myself very well...
I would like the whole row to be hidden if formula in column a returns nothing
it is an if formula so if the formula criteria is not met it brings me nothing, so if nothing is brought forward i want to be able to have the row hidden automatically
so for example something in cell a6, nothing in a7, something in a8, i want the whole of row 7 to be hidden so row numbers would read 1,2,3,4,5,6,8
thanks
You'll need a VBA procedure to do what you want.
If, after a reasonble amount time has passed (whatever that is?) and you still have not recieved a solution, try starting a new thread in the VBA Programming forum.
Good luck!
Can't hide a cell can hide a row or a column - do you want to hide rows??
Try this in the sheet module:
It works with the run but not by single stepping!
Please Login or Register to view this content.
Directions for running the routine(s) just supplied
Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Open a macro-enabled Workbook or save your Workbook As Macro-Enabled
Click on the appropriate sheet
Type "Option Explicit" then paste the code under it
And, you should be ready to go
Last edited by xladept; 06-25-2013 at 04:29 PM. Reason: Improvement in code
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Still can't get this to do as i want.
Correct i do want the row to hide if the first cell of that row = 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks