Search results

This song must have been performed on the Muppet Show at some point, yes...?

With significantly fewer time signature changes though!!

Tool perfectly summed up this phenomena of humanity's incessant thirst for watching horrible things in their song Vicarious in 2006. (Song starts at 50 sec for those who want to sing along). So it's nothing new really, just different platforms of accessibility. Eye on the TV 'Cause tragedy...

Well being a nano brewer and having a B.Sc (Wine) I almost feel that this thread is custom made for me! Now if I had to pick a favourite.. wine - probably a Gewurztraminer from Alsace beer - Pilsner Urquell (Czech Republic)

How about having this formula in the count column of your summary sheet or am I missing something..? =COUNTIF(X_Report!$E$12:$E$68,Summary!B2)

Cafe de Paris butter sauce on steak. 🤤🤤🤤

Just posting an update so as to mark this as solved. After having daily problems with this error I applied the Registry hack on my PC listed in this website in December and have had zero problems since. Much relief...

I'm wondering if this comma is your problem. "...Formula2:="99999999,99" I ran this code but replaced the comma with a decimal point and it ran fine. Then I changed my regional settings so that the decimal symbol was a comma and the code would only work if I had a decimal point in this...

I I think you neglected to take Leap Years into account - not helped by the fact that 1900 wasn't a leap year but MS Excel incorrectly states that it was.

WhatAboutism Unfortunately I see this is becoming more prevalent in general society also as a lot of these new-age woke people seem to really like to argue yet they lack a solid basis or sufficient information to actually participate in any form of cogent debate.

You don't want to replace the whole line with your discrete reference, just the relevant bit within it, so it should still look something like this <v:imagedata src="C:\Users\UserName\AppData\Roaming\Microsoft\Signatures\Darrell_files\image001.png" o:title="Darrell"/> See if that helps

Except if your number is 182. You may want to add an = to the last condition. IF(AR5>=182,"> 6 Months pls")))))

Somehow this doesn't surprise me...

Good on you - I wrote it for a reason, so I guess we're on the same page then.

Sorry - yes the one referenced. Has proven a saviour from much frustration.

Interesting - I've been using this technique to start a new Excel instance for almost a year now as I found that if I opened a spreadsheet to run a macro and I already had other sheets open with their own macros, even though they weren't being referenced, the macro I wanted to run would run up...

Easy - The dogs represent your remaining rational braincells who every now and then get a glimpse of reality and are desperate to escape the prison that you have them in. Poor things, better to just put them down before their paws turn into bloodied stumps...

Thanks Colin, certainly seems that way. Have restored from backup now, running OK and looking at plan B which is doing something else other than creating and deleting temporary tables.

Yeah I guess I'll have to read up on how to do it properly as I've not needed to do it before. Thanks though.

Possibly yes. EDIT: OK make that a firm yes, just spoke with the guy and he'd been in it. Oh well, that's one way to learn :D