Results 1 to 7 of 7

hide rows If a cell value is zero.

Threaded View

Benb hide rows If a cell value is... 12-23-2008, 08:05 AM
JBeaucaire Put this macro into a Module... 12-23-2008, 08:17 AM
davesexcel Hi JBeaucaire, Are you sure... 12-23-2008, 08:26 AM
JBeaucaire Hehe, funny how little words... 12-23-2008, 08:29 AM
Benb Solved! 12-23-2008, 08:54 AM
adamsjc Re: hide rows If a cell value... 08-26-2011, 09:56 AM
JBeaucaire Re: hide rows If a cell value... 08-26-2011, 10:57 AM
  1. #1
    Registered User
    Join Date
    12-23-2008
    Location
    Brisbane, Australia.
    MS-Off Ver
    2003
    Posts
    7

    hide rows If a cell value is zero.

    Hi,
    I'm a beginner and need some help....

    How would I write a macro to hide a range of rows If a cell value is zero, then do the same for five additional ranges of rows?

    In my words:
    If AT214=0, hide rows 214 to 244
    and
    If AT245=0, hide rows 245 to 278
    and
    If AT279=0, hide rows 279 to 311
    and
    If AT312=0, hide rows 312 to 344
    and
    If AT345=0, hide rows 345 to 377
    and
    If AT378=0, hide rows 378 to 410

    Any help to put me on the right path would be greatly appreciated!
    Ben
    Brisbane Austraila
    Last edited by VBA Noob; 12-23-2008 at 09:20 AM.

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