Search results

No idea when it is buy my money is on the devil.

You need vba for this which triggers when the cell J3 changes to 0 and uses the now function to write the value to a cell. There are lots of examples of this about.

You want to use INDEX and MATCH =INDEX(A1:F2,1,MATCH(0,A2:F2)) The above will return the value in row 1 of the column where it matches 0 in row 2 if you have data in the range A1:F2. Not going to be the right solution if you have a bin reaching 0 more than once a month though.

I think what you suggested is the normal way of doing it and I use "is =" out of habit. I just wish my house was as neat as my code.

That shouldn't make any difference afaik brian.

I was giving Mike the benefit of the doubt that he hadn't sufficiently articulated his view and that it wasn't substantially different from my own, but your interpretation of his post is certainly how it reads literally.

I agree with Adam, much as it shocks myself. I see no reason that the arguments and bickering could by at least some, and certainly for myself, be considered cathartic and even enjoyable. If heated debates and argument are not your thing then I can understand why people would choose not to be...

I think this is misleading. Yes a pleasant exchange of information can and should be had in many threads but occasional threads where there are heated debates and arguments happen should also be expected, particularly on controversial topics. I see neither extreme as being attractive, i.e...

I forgot about this. The code is correct just make sure that the case and spelling is correct for your worksheets.

Yeah this bickering and arguing is outrageous. How dare people actually have a bit of fire in their belly about a topic. This board would be much better if we all just got along and painted everything a shade beige.

Have you even read my posts? If so you might want to work on your comprehension of english a bit if you think what you wrote above is a rebuttal to the points I made.

If it was decided that this was the thread rules then no problem I would abide by them, I wouldn't agree with them but I would abide by them. The more important popint is that it is not the thread rules it is Bob's rules that he has made up. Setting a precedent for moderators to make up rules as...

My preference is for removal of posts that the author doesn't approve of not to be removed. BUT if the decision is taken that this should be permitted then it should be applied to all thread authors and not just threads where the moderators are the the thread authors.

I missed that originally. No I don't agree. While you may have correctly interpreted my actual postion the reasons you gave are incorrect.

Try changing the clearcontents to delete

Which opening post are you referring to?

Well if you're going to make uninformed assumptions about my motives you should expect to be wrong a lot.

Not sure I follow. My position is I am against moderators making up their own rules for their threads just because they can enforce it. Unless moderators are going to extend this right to all thread authors and make any edits requested by the thread author. As far as I am aware there are board...

There might be a blank string or something in one of the cells. try changin the line where contents are cleared to: summSheet.Range("A2:IV" & lastRow).ClearContents

I thought this was meant to be a community or something so why not use that as an analogy. In most communities it is not the diktat of community leaders that decides the rules but rather the consensus of the community which is then implemented by the community leaders.