View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mgronov - ExcelForums.com mgronov - ExcelForums.com is offline
external usenet poster
 
Posts: 3
Default Hide colums based on dropdown list

I like to be able to hide/unhide colums based on a dropdown lis
selection
The 1st column starts in K and the 7th column in Q

If dropdown selection = 1, then hide columns L to Q, show columns
If dropdown selection = 2, then hide columns M to Q, show columns K-
Etc til
If dropdown selection = 2, then show columns K to

Is there a way to do this in VBA. I've been trying to do this bu
without any success
Any help is appreciated

Michae
--------
Message sent via www.excelforums.com