The Official Status Thread
-
Status:
-
Status: f*ck Excel VBA
Doesn't work:
Worksheets(SourceSheet).AutoFilter.Range.CopyWorks:
Worksheets(SourceSheet).Activate
ActiveSheet.AutoFilter.Range.CopyFirst one does the copy but based on the entire table not taking the filters in account. The second clicks on the worksheet tab and does the copy action correctly.
Fake edit: Damn @OffByOne !
-
STATUS wtf! a recruiter just called with a wonderful offer for an interview in Scotland somewhere which I, not so sadly, had to decline. They then asked me if I knew someone who might be interested and offered a £100 John Lewis voucher as a referral bonus if they got the job. You'll probably get about two grand for referring someone and you're offering me a john lewis voucher. Fuck right off!
In other news I've being bitten by tuple libraries once again. This time a Quintet buried in a couple hashmaps. I wrote this code this morning and it works. I went to the gym and now I can't remember how...
I'll probably have to start from scratch again.
-
-
@RaceProUK said in The Official Status Thread:
now I know what Hell looks like
Hell is other peoples' hedgehog cakes.
-
@Luhmann said in The Official Status Thread:
Status: f*ck Excel VBA
Doesn't work:
Worksheets(SourceSheet).AutoFilter.Range.CopyWorks:
Worksheets(SourceSheet).Activate
ActiveSheet.AutoFilter.Range.CopyFirst one does the copy but based on the entire table not taking the filters in account. The second clicks on the worksheet tab and does the copy action correctly.
Fake edit: Damn @OffByOne !
I've run into a similar issue. VBScript, actually, but integrating Excel.
Excel tracks the active selection on each worksheet separately, right? (When you activate a worksheet, the selection is the same as the last time you left it.) So you should be able to set the selection on any given sheet, right? Well... not quite.
Works fine... IFF
row.Worksheet
is the active sheet. Otherwise, crashes:row.Cells(1, 1).Select
What you have to do to avoid crashing randomly:
Set ActiveSheet = XL.ActiveSheet row.Worksheet.Activate row.Cells(1, 1).Select ActiveSheet.Activate
It's accessing a workbook that's already open and which the user () also enters data into manually, so the sheet that's left active can vary. Really confusing when the script crashes only some of the time and you're not sure what the problem is...
-
-
@RaceProUK The hideous blue frosting zombie absorbs the magic, stretches, grunts and morphs into a Ben L cake.
http://i.imgur.com/KCTpR.jpg
-
Status:
F*ck Microsoft what have you been smoking ...
Standard SharePoint 365 mail notifying you that you gave someone access to something. I still don't know who would like these messages to begin with but today I get messages with a Dutch subject and euh ... Scandinavian content ... probably some way of Microsoft to express their support for Sweden considering the tragic events of Some Friday.
-
@Luhmann fake Office
-
-
@Tsaukpaetra said in The Official Status Thread:
I always thought PiE was a bad idea...
Yes, if for no other reason than that if you can actually do it, either your partner's ear is grotesquely large, or your penis is absurdly small.
-
@HardwareGeek
So @Tsaukpaetra fancies ginormous ears or ...Yeah let's just keep it at that
-
@flabdablet said in The Official Status Thread:
fake Office
No. The data I blurred was very much referencing actions I took minutes before
-
@HardwareGeek said in The Official Status Thread:
your partner's ear is grotesquely large
-
@Luhmann Bah. Enemy of America!
-
@dcon said in The Official Status Thread:
we're in the process of being washed away so I can't do anything outside. At least I have power.
Not washed away, but there's almost certainly water in my storage unit again. I need to find the insurance policy that I'm paying $15/month for, and see if it covers water damage. The last set of storms wrecked the legs of an antique, heirloom dining table.
-
@flabdablet said in The Official Status Thread:
fake Office
Given that it's written in (something approximating to) Swedish, Öffice?
-
@dkf An Öffice once bit my sister...
-
@abarker said in The Official Status Thread:
As if President's Day actually means anything
Apparently, a lot of people celebrated Not My President's Day yesterday. Carrying signs with pictures of every recent Republican president. Only Democratic Presidents are legitimate, I guess.
-
@RaceProUK
Does she have exceptionally large ears?
-
@Luhmann said in The Official Status Thread:
Does she have exceptionally large ears?
-
@Luhmann said in The Official Status Thread:
Status:
F*ck Microsoft what have you been smoking ...
Standard SharePoint 365 mail notifying you that you gave someone access to something. I still don't know who would like these messages to begin with but today I get messages with a Dutch subject and euh ... Scandinavian content ... probably some way of Microsoft to express their support for Sweden considering the tragic events of Some Friday.
Mwahahaha!
First we take Belgium!
Then we take......
um...
...
St. Bart?
-
@Luhmann said in The Official Status Thread:
Does she have exceptionally large ears?
I know not from whence this meme did appear.
-
@RaceProUK can someone explain this one?
-
@RaceProUK said in The Official Status Thread:
@Luhmann said in The Official Status Thread:
Does she have exceptionally large ears?
I know not whence this meme.
Removed redundancies.
Or try the ablative form:
Meme appears,
knew @RaceproUK not.
-
@RaceProUK said in The Official Status Thread:
I know not from whence this meme did appear.
@fbmac said in The Official Status Thread:
@RaceProUK can someone explain this one?
As far as I can tell, it started a few posts upthread:
@Tsaukpaetra said in The Official Status Thread:
@Weng said in The Official Status Thread:
be fucking deaf.
I always thought PiE was a bad idea...
-
Status: Entering the 3rd week of joining this company. So far so good.
I now have a much stronger idea that by joining a company that offers higher wages, the "average skill level" of colleagues would also be higher. This is the first workplace that I've ever been that has no newbies level I.T. staffs.
Since for a long time in the past, I was often one of the most "technical skill capable" staff in my team or even the company, this is new to me.
-
@dkf said in The Official Status Thread:
OTOH, if you're
usingmodifying stuff that is GPL or AGPL licensed, you need to either stop doing that or think about making your code also be under the GPL or AGPLIf you're just using GPL software, you just need to provide the source code of what you're using.
EDIT: TIL Stallman disagrees :/ This is why I'm not a lawyer.
-
Status: The office drinks machine is out of tea.
-
@RaceProUK Um. Shouldn't that be
Miiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii!
-
Update: More tea has been found.
http://img.pandawhale.com/post-26029-kermit-the-frog-YAY-gif-0hBT.gif
-
@RaceProUK I gave up and started bringing my own, because the Earl Grey they had at the old office wasn't very good and ran out immediately. Then we moved offices, and they tell us they'll bring back tea, but at the moment the only tea comes from an awful machine that can only make it as bitter as possible. It manages to make undrinkable chai tea even...
-
Status: Linting complete. Isn't it nice when major language changes mean that the "best practices" (in quotes because of Apple) change wildly over six months or so.
Oh, and also--my early practices were really really awful. Error handling? what's that?
-
Status: Someone "fixed" my horrible stateful static nonsense with a "singleton" that has a method to reset the instance. I'm glad they tried to come up with a solution, but all they really did was make it wear a different costume. This PR shall not pass.
-
@Magus said in The Official Status Thread:
Status: Someone "fixed" my horrible stateful static nonsense with a "singleton" that has a method to reset the instance. I'm glad they tried to come up with a solution, but all they really did was make it wear a different costume. This PR shall not pass.
-
@abarker said in The Official Status Thread:
my employer doesn't observe President's Day
Mine does, but I don't. As a contractor, I only get paid for billable hours, so unless I work, I don't get paid. I worked most of the day, so I only have a couple of hours to make up during the rest of the week.
-
@sloosecannon said in The Official Status Thread:
STATUS:
Been nice knowing everyone...IIRC, your big concern was pre-existing conditions.
House Republicans have repeatedly said that they would continue providing some protection for people with pre-existing medical conditions.
-
@accalia Precisely.
-
@Magus said in The Official Status Thread:
@accalia Precisely.
IMGUR meme generator FTW (you are free to use that one as you wish.)
-
@boomzilla said in The Official Status Thread:
some protection
Does not make me feel particularly safe. Especially considering the protection in Obamacare was very basic to begin with.
-
@Polygeekery said in The Official Status Thread:
If we are clam
-
@Tsaukpaetra said in The Official Status Thread:
Yeah, of course it's "Not Responding", it crashed so hard you don't even know it doesn't exist anymore!
What do you expect? It's not just broke; it's broker.
-
Status: Maybe this "exercise" thing is just more trouble than it's worth...
-
@HardwareGeek said in The Official Status Thread:
@Polygeekery said in The Official Status Thread:
If we are clam
it took me about five months to notice the @accalia in your avatar.....
-
@cartman82 said in The Official Status Thread:
I'm not really looking too hard into what they are doing there.
The SEC, on the other hand...
-
@accalia said in The Official Status Thread:
it took me about five months to notice the @accalia in your avatar.....
/me looks at @HardwareGeek's avatar closely
...well, fuck me* with a Piko Hammer, you're right!
*Figuratively, obviously
-
@accalia said in The Official Status Thread:
@HardwareGeek said in The Official Status Thread:
@Polygeekery said in The Official Status Thread:
If we are clam
it took me about five months to notice the @accalia in your avatar.....
I can't even recall reading it before now. It scrolled past my eyes many times, but at no point did any conscious thought go into deciphering the letters.
-
@anotherusername said in The Official Status Thread:
@accalia said in The Official Status Thread:
@HardwareGeek said in The Official Status Thread:
@Polygeekery said in The Official Status Thread:
If we are clam
it took me about five months to notice the @accalia in your avatar.....
I can't even recall reading it before now. It scrolled past my eyes many times, but at no point did any conscious thought go into deciphering the letters.
Yeah. I see it and think
KEEP
CALM
IT'S JUST
HARDWAREGEEK
-
@accalia said in The Official Status Thread:
it took me about five months to notice the @accalia in your avatar.....
It took me until that post to notice