Remove Filters from excel using vbs

[daillest319]

i need help i tried the following in VBS to remove the filter and nothing works


.usedrange.autofilter
.Range("A1:B1").AutoFilter

both dont remove the filter in row 1

 

[SkipVought]

Your first statement REMOVES filters; your second improperly applies filters!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[daillest319]

your right sorry i was using it wrong. thank you