+ Reply to Thread
Results 1 to 5 of 5

Help with range hide unhide column

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Help with range hide unhide column

    Hello

    i wish to hide and unhide this ranges of column and some more i can add later, but canot get it to work, B:B,J:J,L:L,M:M,N:N,P:P,R:R,S:S,T:T,U:U,V:V,Y:Y,Z:Z

    Please Login or Register  to view this content.
    Last edited by dodde; 04-13-2021 at 02:55 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: Help with range hide unhide column

    Example macro code given. modify as you want.

    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Help with range hide unhide column

    Hello

    Thank you :-)

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Help with range hide unhide column

    Please try

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Help with range hide unhide column

    Hello

    Thank you Bo_Ry
    Last edited by dodde; 04-13-2021 at 03:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hide/unhide cells within range
    By lucassdm7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2019, 12:51 PM
  2. [SOLVED] hide/unhide a range toggle
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2016, 03:54 PM
  3. Hide/Unhide Column Range
    By karlosdejackal in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2015, 03:19 PM
  4. [SOLVED] Way to Hide/Unhide a column? Please Help.
    By jtmoore in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2014, 08:42 AM
  5. [SOLVED] Hide unhide range
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2013, 10:35 AM
  6. [SOLVED] VBA macro that hide and unhide column to respective rows based on first column value
    By janine6192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 06:21 PM
  7. Hide/Unhide Column
    By Elundari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 11:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1