View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Leo
 
Posts: n/a
Default Macro to hide/show rows and columns

Thanks a lot. I will try it out.

"CLR" wrote:

ASAP Utilities, a free Add-in available at www.asap-utilities.com has a
feature that will do this for you..........

Vaya con Dios,
Chuck, CABGx3




"Leo" wrote:

I have a Excel worksheet using cells A1 to H430. There are quite a few empty
lines in this area, and when I print it out I don't want the empty lines. I
want to write a macro that will check column A (row headings), if one cell
has no content then the macro will hide the whole row.

Can someone please show me how this can be done in VBA code? Thanks a lot.