LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Another query about hiding columns with Macros

I have a worksheet that contans data in columns A to BY.
I want to hide columns from some users as they are not interested in all the
data so I recorded a Macro to hide the columns that are irrelevant to those
users, here is the code (after a bit of cleanup):

Sheets("Internal Portfolio").Select
Range("A:G,I:I,L:M,O:Q,S:S,U:BA,BC:BI,BM:BR,BT:BY" ).Select
Range("BT1").Activate
Selection.EntireColumn.Hidden = True
Range("H4").Select

When I run this macro, some of the columns which should remain visible are
also getting hidden i.e. after running the macro, the visible columns are H,
BB, BJ to BL and BS so it seems my Macro is ignoring some of the Range...

Can anyone tell my why this happens and what I can do to fix it?

Thanks!
 
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
Strip workbook of macros, VBA, MS Query, etc. Paul Kraemer Excel Discussion (Misc queries) 4 September 7th 06 01:30 PM
hiding columns [email protected] Excel Discussion (Misc queries) 3 July 12th 06 04:42 PM
Hiding Columns belony Excel Discussion (Misc queries) 4 June 15th 05 12:27 AM
Hiding Macros mrbalaje Excel Discussion (Misc queries) 2 April 18th 05 08:11 AM
Hiding Macros PCn Excel Discussion (Misc queries) 0 February 17th 05 03:47 PM


All times are GMT +1. The time now is 11:43 PM.

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

About Us

"It's about Microsoft Excel"