sheet.columns("K:M").EntireColumn.Hidden = True

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Kevin
one way:
range(Columns(11),columns(13)).entirecolumn.hidden = TRUE

HTH
Frank
 
Back
Top