Last seen: Jun 8, 2026
Cross-posted: mrexcel.com/board/threads/select-the-name-in-the-data-validation-list-on-a-cell-value-then-the-same-name-run-the-sub-macro.1263786/ ...
Will the item you want to select always be present? If not, what do you want to happen?
The code shown in your picture is not the same as the code in your post. The code in the post properly uses a fully qualified range (you specified the...
Glad we could help. 🙂
You cannot use functions on the ranges in a SUMIFS formula as that would return an array, not a range, and the function will not accept anything other...
You should also note that if you cross-post to multiple forums, etiquette dictates that you provide all links in each forum so that people don't dupli...
Your first version of the formula didn't have the additional text argument after "Replen" that your second version does have. The second one shouldn't...
It can be done in Lists. A simple way is to create a calculated column that subtracts the review date from TODAY() (or vice versa) and then you can co...
A macro wouldn't be that complicated - though I suspect you might be able to get the result you need just using something like the camera tool - but i...
You could use: =LOOKUP(2,1/(B4:J4<>0),B$1:J$1)
The formula is basically: =LOOKUP(2,1/(Column1<=LookupDate)/(column2>=LookupDate),column3) where LookupDate is your lookup date, column 1 ...
That's either pure luck or they simply haven't reported it. Getting API calls wrong tends to lead to applications terminating without warning, and tho...
@Hans Most of those VBA7 declarations are wrong for 64 bit. All handles and pointers need to be LongPtr not Long. You can't just put PtrSafe into a...
And which version of Excel do you have?
AND and OR only return one result, not an array of results. so you would need to enter the correct formula into one cell and copy it down - eg =IF(...
