Search results

:confused: So the event is not true but the numbers of people is? Water does not have to be deep to drown you if the current is strong. I suspect an event happened but not as per the biblical story, like other stories in the bible a totally unconnected happening is given significance by the...

Did a Google search and came up with this http://www.mrexcel.com/forum/excel-questions/621177-problem-selection-column-merged-cells.html When I put the code cells.mergecells= false as the first line in the selectionchange event all worked. I will leave you to tweak your code as I have things...

I Mentioned the looping and its reason earlier, it , and the avoidance of a message when an empty cell has data entered for the first time, can be programmed out with simple if statements Eg if original = target exit sub I said that t he code was crude, it was to illustrate that what you wanted...

People can spend hours in Morecamb Bay, but when the tide starts to come in you have to be out of there PDQ as it is faster than a horse can gallop, it knocks you off your feet and you drown, as those Chinese Cockelers found. If Moses had lived in the area where he crossed he would have the...

Any progress..?

I think it is more likely to be due to tidal action such as we experience in Morecamb Bay, and which nearly drowned Napoleon in the Gulf of Suez Brian

I defined original as a variant as it will handle most data types, if you know the data type you could define it as that type, however variant will not handle user defined types or cells with errors IE #N/A but I don't expect that applies in this case for the update, but if moving through the...

I can only give a partial yes but with extra coding it may e possible, the bit I haven't done is for the first time ignore but I guess you could test for that. You need to use two Worksheet events as shown in the code below, but note that the Change event will be triggered after the update and...

Isn't there code here that could be modified to do what you want? http://word.mvps.org/faqs/macrosvba/DeleteFiles.htm Brian

:( there are times when I feel so old and ignorant, thankfully Google and wiki can help the latter. :D Brian

The land of Who's Telling Fibs. I thought you had decided on that a few posts back. ;) Brian

A frequent problem when quoting cell references :D is a green smiley, to avoid this problem you need to turn smilies off Disable smilies in text is in additional options below the message pane. Brian

Code Button I suspect you mean "as well as" not "rather than" As I rarely used the quick reply I make no further comment. Multiple Spaces etc YES YES YES PLEASE. I no longer participate in the techy areas, 74 and 10 years retired, but while I did the lack of format facilities , even such...

Not sure I fully understand but I think that you need to differentiate Where and Having clauses I think that your check for true/false needs to be in a Where clause, this takes effect before aggregation and is created in the design grid by selecting Where from the Total menu, the Show box will...

Blade, did you read the article or just the headline? Brian

If you followed the thread you would find I had answered that in post 112, kit was the WHO. NO NOT THE BAND OR THE DOCTOR but the World Health Organisation. Keep up Col Brian

Oops one last post for now The he is the WHO and it's really pissed off the Germans. I'm having pizza tomorrow round at my other daughter's with the grandkids , gee it's a hard life. :D Brian

Back on track my fast of 6 hours is almost up so I'll sign off and head round to my daughters for dinner, fish I believe so I've rescued a bottle of Sauvignon blanc semillion from the fridge. Have good weekend and Halloween folks . Brian

Especially if it's got a decent slurp of liquor in it. Brian

Col I have a sort of salad for lunch most days, lettuce, tomatos, cucumber, peppers with a bit of cold meat or cheese , but I cannot stand salad with a hot dish. This latest scare story about processed meat, well I guess I should be dead now, garlic sausage, pepperoni, and cured ham are staples...