View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney[_2_] Kevin McCartney[_2_] is offline
external usenet poster
 
Posts: 32
Default sheet.columns("K:M").EntireColumn.Hidden = True

Hi
I need to know how I can do the following 'Columns("K:M").EntireColumn.Hidden = True' but where the column is a character I need to have the corresponding number e.g. K is the 11th column and M is 13th so something like 'Columns("11:13").EntireColumn.Hidden = True

any help much appritiate

regard
K