I am in need of a way to filter a worksheet then sum one column, and capture the first non 0 or null value for another. I have spent hours working on this and am unable to get the syntax exactly right. I have attached a sample workbook with sample data and set-up, and the VBA that I have tried.
How should code be altered so that my desired value is returned?
Hi,
You could do this
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
@xlnitwit:
I was coming up with a similar solution, but just FYI, you don't have to do the IsNumeric check, you can just do a specialcells subset of a specialcells set. Given a large enough data set, the speed up would be noticeable.
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
@walruseggman,
Great name!
That is true, although
1. You need to break that into two lines, because if the first specialcells method only returned one cell, the second would apply to the entire sheet.
2. If I had a really large dataset I probably wouldn't use an autofilter at all.
Actually, scrap point 1. It seems that doesn't apply if you chain specialcells commands. It would still need an error handler though.
Last edited by xlnitwit; 03-23-2017 at 12:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks