View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Is there a formula to hide/ display row based on cell value in Exc

Rick,

An Excel formula can only place a value in the cell in which it is written;
it cannot perform functions such as hiding or deleting rows. You would need
to resort to code for that.

Mike

"RickA" wrote:

Excel 2003.

Is there a formula to hide or display a row/column based on the value of
another cell?