+ Reply to Thread
Results 1 to 6 of 6

Hide columns that do not have numeric value

  1. #1
    Registered User
    Join Date
    02-13-2019
    Location
    canada
    MS-Off Ver
    2010
    Posts
    56

    Hide columns that do not have numeric value

    I have been beating around this bit of code for an embarrassingly long time. I have changed the excel formulas on the sheets due to graphing requirements and now have the cells "blank" vs the "0". I was trying to incorporate isnumeric but every which way I try it kicks back errors. Any help would be gratefully appreciated.
    Please Login or Register  to view this content.
    Last edited by alansidman; 05-23-2020 at 05:55 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Hide columns that do not have numeric value

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: Hide columns that do not have numeric value

    So you have formulas in your columns that display either (the quotes are yours) as "0" (is this really text or should it be an unquoted number?) or ""... is that correct?

  4. #4
    Registered User
    Join Date
    02-13-2019
    Location
    canada
    MS-Off Ver
    2010
    Posts
    56

    Re: Hide columns that do not have numeric value

    The formulas generated a zero, no quotes. But now when they calculate they are empty.

    NOW -
    Please Login or Register  to view this content.
    Previously -
    Please Login or Register  to view this content.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Hide columns that do not have numeric value

    Maybe:

    Please Login or Register  to view this content.
    And, Thanks Rick,

    Orrin
    Last edited by xladept; 05-24-2020 at 01:12 AM. Reason: Correction per Rick
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  6. #6
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: Hide columns that do not have numeric value

    Also a maybe...
    Please Login or Register  to view this content.


    Note to xladept: You omitted your Next statement
    Last edited by Rick Rothstein; 05-23-2020 at 06:34 PM.

+ 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. [SOLVED] Auto Hide Columns that starts with a Numeric Value
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2019, 10:04 AM
  2. Mass (specific) Hide/Un-hide Columns
    By BarryB75 in forum Excel General
    Replies: 4
    Last Post: 06-18-2019, 02:18 PM
  3. [SOLVED] Automatically Hide or not Hide columns, based on cell value (to the left)
    By sherylt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2018, 07:47 PM
  4. Hide Rows/Hide Columns Based on Value in Cell
    By brickwall823 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2015, 02:42 PM
  5. [SOLVED] Hide - Un Hide rows with empty columns
    By BDF in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-14-2014, 02:09 PM
  6. Formula to align two columns with nearly similar text and attached numeric columns
    By Benefits Recon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 12:03 AM
  7. Hide numeric rows of dynamic range
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 09:53 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