Hide rows using VBA

B

buzzandbeyond

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
 
Top