Search results

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...

I don't like peanut butter but I know lots that do so whether in general we Brits don't eat it or not I can't say. People who don't like liver usually object to the texture as much if not more than the taste in my experience. As you say we all have our quirks. Brian

Frothy oh Frothy, YOU DON'T EAT OFFAL !! :( Hearts, Kidneys, Liver are the best parts of the animal. Made a steak kidneys and onion casserole the other day , great Brian

Come on what's wrong with a diet of battered Cod, chipa, black pudding and faggots, besides we have peas, and the other day they had grapes in Tesco's, not that I got any as I was elbowed out of the way by the old ladies, but there was a grape left in the box so I had that, that should keep me...

All that food and he is short of "e" vitamins/numbers 😎 Brian

Don't worry Dick Col threw the last one in as part of his obnoxious attack on you, suss is basically short for suspicious in Col's use of it. In other uses it can mean check, as in I'll suss it out. I may not agree with you on issues, but that is no excuse to be rude, he could decline your...

Dick when reading your post I noticed a typo in mine, that should be "gym or MacDonald's, it kind of changes the meaning, I presume in the gym of MacDonald's one works out lifting beef burgers ! Brian