Hiding rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 28 Aug 2007 22:32 GMT

Hello to All,
In relation to my previous posting I thought of something else but still
need help:
=IF(Constants!B25<>"",Constants!B25,Hide current row) is the formula in cell
A32

What would be the correct syntax to "hide current row".
If it can be done with this formula it is fine .

thanks in advance for any help

Reply to this Message

Earl Kiosterud - 28 Aug 2007 22:43 GMT

Khalil,

Formulas can only return a value to the cell in which they live. They can't "do" anything,
such as put a value in another cell, hide a row, make coffee or any other thing. Automatic
hiding of a row based on some conditions could only be done via an even-fired macro.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> Hello to All,
> In relation to my previous posting I thought of something else but still need help:
[quoted text clipped - 4 lines]
>
> thanks in advance for any help

Reply to this Message

Ron de Bruin - 28 Aug 2007 22:48 GMT

See your other thread

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hello to All,
> In relation to my previous posting I thought of something else but still
[quoted text clipped - 6 lines]
>
> thanks in advance for any help

Reply to this Message

Khalil Handal - 29 Aug 2007 14:28 GMT

Thanks.
I will try to mnage with the code (so as not to use it for printing) .

> See your other thread
>
[quoted text clipped - 8 lines]
>>
>> thanks in advance for any help

Reply to this Message

Rate this thread: