View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default if cell empty hide row macro?

Range("AD:AD").SpecialCells(xlBlanks).Entirerow.Hi dden = True

--
Regards,
Tom Ogilvy

"Todd" wrote in message
...
Hi, I need a macro that will hide rows if a cell in column AD is empty.

Can anyone help me?


Thanks

Todd