Thread: VB Code to hide rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Lonnie M. Lonnie M. is offline
external usenet poster
  
Posts: 184
Default VB Code to hide rows
Correction:
* Columns(1).EntireColumn.SpecialCells(xlBlanks).Row s.Hidden

Should read:
Columns(1).EntireColumn.SpecialCells(xlBlanks).Row s.Hidden = True
Reply With QuoteReply With Quote