View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Turner
 
Posts: n/a
Default Conditional hiding of entire rows

Hi All

I was wondering if anybody knew how to hide an entire row or column based on
a stated condition using a specific cell elsewhere on the worksheet. I know
that it is possible to use [Format] Conditional Formatting to make the cell
appear empty, but I want to hide the entire row or column so that it no
longer appears on the worksheet. Is there a way to do this with or without
using VBA?

Thanks in advance and have a happy new year.

Nick