XL2007 showing hidden rows when autofilter used

[Sparkle99]

Am I using autofilter correctly ?
I'm setting autofilter in the usual way across some columns in VBA code.
Every alternate row is hidden.
(I've tried .EntireRow.Hidden = True and RowHeight = 0)

When the autofilter is then used, the rows matching the filter that are hidden are then shown.

Is there a setting I can use to prevent this ?

Cheers in advance !

 

[AlphaFrog]

You want to autofilter but not show even numbered rows? Is that correct?

If yes, I suggest you have a column filled with alternating True\False. Then autofilter on your other columns and include this new column to have a True or False criteria.