Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum a range of columns ? | Excel Discussion (Misc queries) | |||
Range of columns | Excel Programming | |||
Range of columns | Excel Programming | |||
Using Columns().Row() To create a range | Excel Programming | |||
No of columns in range | Excel Programming |