I've done this alot before when I worked at E&Y.
If you know how to code basic VB in excel you could do it by adding an
additional column (I) that takes the ABS value of column F + Column G). Copy
this formula all the way down so it starts at cell I18 to Ixxx

Sub HideRows()
calculate
range("I18").select
Cells.EntireRow.Hidden = False
do
if Activecell.value = 0 then ActiveCell.EntireRow.Hidden = True
Activecell.Offset(1,0).select
loop until activecell.Formula = ""
end sub

"JMay" wrote in message news:UZWVa.2854$Or.2450@lakeread06...
Each Month I need to fill in a Standard journal entry (Columns A-H with
Column F (Debits-$$) & G (Credits-$$)). There is 17 rows of header
information and beginning on row 18 I begin the regular detail account
text
and Dr/Cr update. Some months my line # say 20, 25-28, 35 and 38-45 may
have $0.00 dollar amounts. I wish to leave the lines intact on the
worksheet, but hide all rows that have either the 0.00 in either the Debit
or Credit column or are Blank (both in Column F & G). Could someone help
me
with the code that I can assign to a button (I can do that) where I can
have
(the Macro) it collapse such 0.00 rows and give me only positive rows??..
TIA,,