Results 1 to 2 of 2

Macro to Hide Columns Where Sum is Zero

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    seattle
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro to Hide Columns Where Sum is Zero

    I have a spreadsheet where I want to be able to create a macro button to hide a column when the sum of a row is zero.

    I tried following the code to a similar question posted at (http://www.excelforum.com/excel-prog...itionally.html), but I couldn't get the code to work after trying to modify it to my specifications.

    Hopefully this attachment works (first time poster), it is just one of the tabs I would like to apply it on.
    Attachment 215817

    What I would like to be able to do is click a macro to hide a column from E through AO to be hidden if the value in Row 31 is zero to clean the sheet up.

    If anyone has any incite or could build off the related post, I would really appreciate the help.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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