sub hideem()
if len(application.trim(range("i8")))<1 then
rows ("5:30").hidden=true
end if
end sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DarrenL" wrote in message
...
I want to hide rows 5-30 if cell (I8) is empty.
any thoughts?
Thank you.