View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
buzzandbeyond buzzandbeyond is offline
external usenet poster
 
Posts: 4
Default Hide rows using VBA

Hi,

I am trying to hide rows with a specific value.

In my sheet I have three columns:
Date - The manually inputted date
Today - 1 Month - 'TODAY() -31' (this column will be hidden)
In Range? - an IF statement to say "HIDE" or SHOW" (this column will
be hidden)

I am looking to hide all the rows where Hide shows in the In Range?
column. I would also like this to run on opening the document

Any advice is gratefully received as my vba skills are almost non
existent.

cheers
Dave