Does anyone know why when I filter my data set, it doesnt capture the data underneath? This is across all my columns. most columns do not have blanks but to my knowledge, as long as the filter is across columns with data in first row, it should capture everything. Any IDeas?
If you have an empty row/column (and I think empty cell in the 1st column?), the filter will only go down that far/across.
To overcome that, 1st remove the filter, then highlight the required range and re-apply the filter
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks