sheet.columns("K:M").EntireColumn.Hidden = True
Hi Kevin
one way:
range(Columns(11),columns(13)).entirecolumn.hidden = TRUE
HTH
Frank
Kevin McCartney wrote:
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 appritiated
regards
KM
|