View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] woeilin.eng@gmail.com is offline
external usenet poster
 
Posts: 1
Default Drop down bar to hide column according to the content of a cell

Hi all,

I need help. How can i write a macro such that
when the user select (e.g. 2 ) from the dropdown for, it hides column
G:Z
when the user select (e.g. 5) from the dropdown form, it hides Column
J:Z

Thank you so much.

Cheers
WL