One way
sub hideifzero()
for i=1004 to 2 step-1
if cells(i,"ck")=0 then rows(i).hidden=true
next i
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumsab" wrote in message
...
Greetings,
Newbie here so any help is appreciated.

Within the active worksheet, within the row range of Row 7 thru Row 1004,
if
the value in Column CK for that Row is = 0, then hide the entire row.