Results 1 to 4 of 4
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: function for zero values in cell (Excel 2000)

    Just loop through all the cells and check each cell for whatever conditions you want.
    Legare Coleman

  2. #2
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    function for zero values in cell (Excel 2000)

    SpecialCells(xlCellTypeBlanks) seems to hide cells only if there actually blank which makes sense, is there a way to hide cells if the formula value is 0' as well?

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: function for zero values in cell (Excel 2000)

    I figured that so I am using
    For Each cell In Range("E11:E91")
    If cell.Value = 0 Then
    cell.EntireRow.Hidden = True
    End If
    Next cell

    Thanks for the reply

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: function for zero values in cell (Excel 2000)

    That should work.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •