Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum a range of columns ? Ainsley Excel Discussion (Misc queries) 6 May 9th 06 10:43 AM
Range of columns fragher75[_2_] Excel Programming 1 September 20th 04 11:36 PM
Range of columns hotherps[_94_] Excel Programming 10 August 10th 04 10:41 PM
Using Columns().Row() To create a range Wandering Mage Excel Programming 2 July 14th 04 11:22 PM
No of columns in range Ron McCormick[_2_] Excel Programming 1 October 8th 03 04:36 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"