Hi,

To hide the columns A to K :
Columns("A:K").Hidden = True

to show :
Columns("A:K").Hidden = false

With a loop you can do the same thing as follows :

Dim i as integer

i = 1

For i = 1 to 10

Columns(i).Hidden = true

Nex

--
Message posted from http://www.ExcelForum.com