View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Using offset following an autofilter

For Each c In Selection
If Rows(c.Row).Hidden = False Then
If iCt = 0 Then
iCt = 1
Else
c.Offset(0, 1).Select
Exit For
End If
End If
Next c

Add this after what you have. Using iCt avoids the header row.

Hth,
Merjet