View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fragher75[_3_] fragher75[_3_] is offline
external usenet poster
 
Posts: 1
Default Range of columns


I reply it...
I hope that someone anwers to me...
I have that problem (excuse me for my english)..
Why in sheet "me" I can use:

.Range(Columns(15), Columns(17)).Hidden = False

and in another sheets can't I?
I used a For cycle to do it!

For k = 18 To 20
.Columns(k).Hidden = False

Is there another way to hidden a range of columns in another sheets?
How can I hidden that columns(15,16,17 e 21) in another sheets wit
only row of code?
Thanks
Francesco

ToggleButton3.Caption = "Nascondi Previsioni"
With Me
.Range(Columns(15), Columns(17)).Hidden = False
.Range(Columns(6), Columns(7)).Hidden = True
.Columns(22).Hidden = False
.Columns(18).Hidden = True
.ToggleButton4.Visible = True
End With
For i = 4 To 12
For k = 18 To 20
For t = 6 To 8
With Sheets(i)
.Columns(k).Hidden = False
.Columns(t).Hidden = True
.Columns(25).Hidden = False
.ToggleButton2.Visible = True
End With
Next
Next
Nex

--
fragher7
-----------------------------------------------------------------------
fragher75's Profile: http://www.excelforum.com/member.php...fo&userid=1236
View this thread: http://www.excelforum.com/showthread.php?threadid=25920