title: View and hide columns in excel using vba
body: <p>I have a worksheet with values in columns B:G. In the same sheet in cell A1 I have made a drop down list using data validation with values like A, B and C.</p>
  
  <p>What I require is when I select cell value A then columns B:C need to be visible and the other columns should be hidden from D:G. In the same way if I select B from the list I need to view columns D:E and B:C and F:G should be hidden.</p>
  
  <p>Could you please help me on this.</p>
  
  <p>Note: I don't have good knowledge in VBA.</p>