View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ferris[_2_] Ferris[_2_] is offline
external usenet poster
 
Posts: 34
Default AutoFilter Header Row

On Aug 17, 11:06 am, bgetson wrote:
I want to apply an AutoFilter to a Structured Table within my
worksheet. Row 1 is a header row, and row 2 contains a series of
inputs needed for calculations within the table. I only want to apply
the AutoFilter to row 3 and down (which contain dates), but my code
always filters out my input row because it doesn't contain a date. I'm
using:

ActiveSheet.Range("A3").AutoFilter field1:=1, ..........

Any suggestions?


Move your inputs in to a row above your table. If your header row is
row 1 in your spreadsheet, just insert a row above it.