Hiding rows

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

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
 
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.
--
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...
 
Back
Top