Thread: Hide Blank Rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Hide Blank Rows

You don't need a macro.

Select a column within the range and F5SpecialBlanksOK

FormatRowHide.


Gord Dibben MS Excel MVP

On Wed, 6 May 2009 08:43:00 -0700, TamIam
wrote:

I don't know how to use macros, (I'm assuming I would need one), but does
anyone know of one I could copy/paste into my spreadsheet that will hide
blank rows within a specific range?