Last seen: May 22, 2025
Filtering for a value that isn't there will not cause an error, you just get no data shown. You can test for that by checking there is more than one v...
If you selected the whole of column D, then D1 would be active by default, so your formula should be: "=D1=$Q$3"
You can use IFERROR to return 0 for such cases. You can also use an array of criteria and SUMPRODUCT to test multiple options in the same field - for ...
Do you mean you actually have the formula =TEXT("0:16","[h]:mm") in the cell? If so, why? It's pointless as it just returns the text already passed as...
No, but you've commented out the code in your workbook and merged two lines together. It should look like this: Function CountCcolor(range_data As ...
Which cells specifically?
That's your original code, not mine. Also, as written it only works on whatever cells you have selected when you run it - was that your intention?
You'll need to handle the * wildcard by replacing it with ~* like this: Sub replaceText() What = replace(InputBox("Word to search"), "*", "...
You've got REF errors in that sample. Can you fix and re-post?
I think you'd need to use something like this as the criterion: IF('Buy and Sell Criteria'!$D$33="",{"*","="},'Buy and Sell Criteria'!$D$33) ...
If you actually have blanks in AN (which your current formula won't actually pick up) that's a little trickier. Do you have blanks? What kind of data ...
You could use a formula like: =IFERROR([@State]<>LOOKUP(2,1/([@Name]=$A$1:$A1),$B$1:$B1),FALSE) which will return TRUE if the current stat...
Replace all the code you posted with this: With Sheet3 erow = .Cells(.Rows.Count, 1).End(xlUp).Row .Cells(erow, 5).Value = Sheets("Invoice").Range(...
If it's always at the end with a space preceding it, you could also use: =SUBSTITUTE(A1," "&B1,"")