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.
|