Search results

have you tried turning screenupdating off? It is the first thing to do whenever your code takes anytime to run.

Maybe we could turn it into a tag team event. We could have jesus and santa versus the devil and the easter bunny, I never did trust bunnies.

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

The journalist probably bought the rednecks a few crates of booze, some petrol, a box of matches and a union flag.

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.

http://www.mirror.co.uk/news/top-stories/2010/06/03/u-s-oil-hypocrisy-makes-me-slick-115875-22305530/ Last time I saw the union flag getting burnt it was a bunch of celtic supporters in glasgow.

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?