+ Reply to Thread
Results 1 to 3 of 3

Hide column macro when criteria in range met

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Hide column macro when criteria in range met

    Sorry for posting this - I have been trawling the internet for the past day or so and just cannot seem to find anything that is suitable (I am an accountant and not completely conversant with macros).

    I would like to hide columns when criteria in a column range is met...

    Example, I would like to look at the range G73:DA81 and hide the column if the formulae is <=0. In other words, if range G73:G81 <=0, then hide column G, similarly H73:H81 <=0, then hide column H.....I, J, K etc.

    Can you also provide me with the details to unhide them?

    Many thanks

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Hide column macro when criteria in range met

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Hide column macro when criteria in range met

    Hi Keeleyb;

    Don't know if you're still looking for an answer.
    The thread isn't marked "Solved", but I don't want to waste your time if you're satisfied.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ 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