I have a sheet that I use sort on a lot and if it doesnt know i have a header it messes it up. I can click on the custom button and click "my data has headers" button but when i close and open the file it goes back to not being default. Is there a way to make it default on load up?
Maybe set filters and use that do do the sort?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I cant use filters on this specific sheet... well i can but it makes it ugly and harder to use. But it will fix the issue if thats all i can do.
is there a way to put a filter on just 2 columns?
You could apply the filter to just 1 column, if you want. Just know that the columns outside the filter range wont get sorted
ok bummer that wont work then. Ill have to use the full filter or just always make sure to select the, my data has headers, checkbox then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks