Hide rows IF #N/A (preferably without marco)

I've been searching for this for a while now, but it seems as if this is only possible with a marco, something i have been fooling around with but found out it is beyond my comprehending.

So basically is there a possibility to formulate a formula which allows me to hide every row that has #N/A in it? (and preferably also some other rows if i could add those in the formula)?

For example: G88 has an N/B, would it be possible to hide row 88:94?

I know this probably isn't possible, but i would like to be certain before starting struggling with marcro's again.

Thanks in advance!

Hi,

It is certainly not possible to hide rows / columns by using formulas. You would need VBA for that.

Please go through the following URLs for help on hide / unhide rows based on result value, you might find them helpful.


http://excel.tips.net/T001940_Hiding...ell_Value.html

http://answers.microsoft.com/en-us/o...7955283?auth=1

https://forums.techguy.org/threads/s...value.1030100/

Thank you very much for your response, the links were usefull since it gave me the idea to try it with filters.
After some tweaking i've almost got it exactly how i want it, but there is only one small thing i'm still struggling with:

If i use the filter to "hide" certain rows out of my sheet,but the page layout changes and some stuff i want to be on page 2 partially goes to page 1, is there anyway to lock the second ''page'' into place? I found out that it is possible to do so with Images, but dind't find a way to do so with text and such.

thanks a lot , exactly what i needed!

Thank you for this suggestion, this is actually what i did, but i still had the need for the empty spaces to disapear, but if kind of done that with a filter (allthough it still needs some tweaking so it will not disturb the lay out) I shall now close this thread, thanks guys!