Thread: macro for hiding rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default macro for hiding rows
Try

Sub hideRows()
For i = 3 To 99 Step 3
Rows(i).EntireRow.Hidden = True
Next
End Sub

Change 99 to the value you want...

"Khardy3352" wrote:

Can you help me write a macro that will automatically hide every third row?
Reply With QuoteReply With Quote