+ 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
    6

    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
    MS-Off Ver
    MS Office 2019
    Posts
    17,381

    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.)

  3. #3
    Valued Forum Contributor
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,057

    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
    6

    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,274

    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
    Valued Forum Contributor
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,057

    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)

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