worksheet change event - filter issue

[jw01]

hello all



i have the following macro that filters data on worksheet change event



the issue is....i would like for it to filter row 13...my name is "_Data"

Please Login or Register  to view this content.

however, my name ranged "_DATA" starts at row 14...therefore when i filter, it does not filter row 13....i dont want to change my defined name as it links to alot of other sheets....is there in the macro after "_DATA" where i can make the macro go up one row from _Data?



pls help!!!!

[arlu1201]

Try this -

Please Login or Register  to view this content.