+ Reply to Thread
Results 1 to 3 of 3

Auto Hide Columns that starts with a Numeric Value

  1. #1
    Forum Contributor
    Join Date
    02-04-2015
    Location
    India
    MS-Off Ver
    365 (2202)
    Posts
    226

    Auto Hide Columns that starts with a Numeric Value

    Hello Excel Experts,

    I'll looking for VBA code to Auto hide the columns that starts with a numeric value. The column name can start with 0.0, 1.0, 1.1 or without decimal no.

    I've attached Excel Sheet for your reference.

    In attached sheet, my columns are starting from B1 and the headers can be till any range.

    In column D, G, K, L, M,O, P, R - the headers are starting with numeric values, so I want a VBA code to hide this columns.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Auto Hide Columns that starts with a Numeric Value

    Please Login or Register  to view this content.
    It could have been just one line if you didn't have the cells formatted as text.

  3. #3
    Forum Contributor
    Join Date
    02-04-2015
    Location
    India
    MS-Off Ver
    365 (2202)
    Posts
    226

    Re: Auto Hide Columns that starts with a Numeric Value

    Thanks Daves ! This Worked like a Charm..

+ 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. Auto delete (or hide) columns
    By SpeakingPeace in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2014, 05:15 PM
  2. [SOLVED] Auto hide columns macro
    By raza_m33hdy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2013, 11:01 AM
  3. [SOLVED] Auto Hide Columns
    By msmac74 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-26-2012, 07:25 AM
  4. [SOLVED] Auto Hide Date Columns--NEED HELP!!
    By abusby in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-22-2012, 03:53 PM
  5. Auto-Hide Columns
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2006, 11:42 AM
  6. [SOLVED] Auto hide/Unhide columns
    By Vespaguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2006, 01:40 PM
  7. Auto Hide Columns
    By Phil Osman in forum Excel General
    Replies: 5
    Last Post: 03-28-2005, 12:08 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