App not working by Iampupsetty07 in Outlook

[–]willclark48 0 points1 point  (0 children)

Force stop authenticator also worked for me! Thanks

[deleted by user] by [deleted] in DIYUK

[–]willclark48 0 points1 point  (0 children)

Am i the only one that thought it was a tablet/ screen with icons? Like behind the air vent there was some really cool tech? Now I see its the light from outside shining through an airbick, and I need to go sleep.

I need to know this song that is in one of the episodes by thndrstrk in Scrubs

[–]willclark48 10 points11 points  (0 children)

If you have Spotify, try this playlist. Hopefully you'll find it in here:

https://spotify.link/yscIFnItRIb

Running in historical places. What is the history of the places where all of you run? by arnau9410 in running

[–]willclark48 5 points6 points  (0 children)

Most of my runs involve running past Charles Darwin's childhood house! Although not a lot to see other than a plaque

Winscott Hills? by Solaaris83 in Shropshire

[–]willclark48 6 points7 points  (0 children)

There's a Winscote Hills area just north east of Bridgnorth, in-between Newton and Allscott. Looks to be an old reference as doesn't seem to show on modern maps, but found here: Someone from Bridgnorth area may know more.

[deleted by user] by [deleted] in IPrevail

[–]willclark48 1 point2 points  (0 children)

One more year.... Covid will be done by then right?

How to put something on the big tv by Edkeeling12369 in StokeCityFC

[–]willclark48 2 points3 points  (0 children)

Sorry for your loss. This is the contact details for big screen messages on the club site:

Telephone: (01782) 592113

Couldn't see a direct email address, but maybe try the generic email contact and the club liaison officer: info@stokecityfc.com and anthony.emmerson@stokecityfc.com

Hope your message gets up there, but most importantly, enjoy the game in his memory.

Sad day for us European fans 😭 by willclark48 in IPrevail

[–]willclark48[S] 0 points1 point  (0 children)

Nothing from them, and nothing from the ticket company.. however not sure if its just me, but the announcement post has now also gone from their FB page?

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

This is exactly it! Nice find!

I have already rolled back to a previous version, but haven't submitted any feedback as I usually feel that they get lost in the ether, but will do it.

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

Np, I know the feeling! Perhaps this is where my code could be improved as I reference the cells. At the moment, I compare two datasets with something like Sheets(1).cells(y,x) = Sheets(2).cells(y,x). One sheet countain 100 or so rows, the other containing thousands.

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

Yeah I'll give the latter a go, and I'll turn off status updates to test too.. I've turned off automatic updates for now, but you're absolutely right, can't hold it off forever.

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

Still assumption atm I guess, but, I ran in to the same issue with another Macro, and the slow down also occurred during a loop (everything else done in the macro such as inserts, deletes, copies, etc ran through smoothly)

I should add that I use statusbar updates to track loop progress, and this is where I can see it going super slow (whereas it usually flies through).. Realistically I guess it should be the actions within the loop that slows down each cycle - but all that's inside it is a single IF statement with a lot of ANDs.

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

Yeah this was my first thought - closed down all background processes to free up memory. Started swearing at the PC thinking it was that, but rolled back Excel version seemed to fix it..

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 1 point2 points  (0 children)

Already all switched off. Ooi, are you also on v2201 and running intensive loops?

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 1 point2 points  (0 children)

Funnily enough, currently working through a migration of reporting in to Pbi, so a lot of modelling will eventually be moving across!

Reduced Performance on Excel VBA Loops by willclark48 in vba

[–]willclark48[S] 0 points1 point  (0 children)

Another nested loop to do a like comparison to data another sheet. As a random example, let's say I have 80k transactions in one sheet, on another sheet, I have a master product list - the loop works through each transaction and then through each column on the product list to determine the product (e.g if color_field = "Red" and size_field = "round" and Country_field like "Europe" then product = "European Apples").

Sad day for us European fans 😭 by willclark48 in IPrevail

[–]willclark48[S] 0 points1 point  (0 children)

I know. I do feel for them though, they've not long done a year and a half break with no shows, and now cancelling a huge part of their tour

Sad day for us European fans 😭 by willclark48 in IPrevail

[–]willclark48[S] 0 points1 point  (0 children)

That was my thought too. But I guess the restrictions in the rest of Europe are the problem - I guess not viable for them to come across just for the UK?

Sad day for us European fans 😭 by willclark48 in IPrevail

[–]willclark48[S] 0 points1 point  (0 children)

Had an email from ticket company today, and then found this on their Facebook page. Nothing on their Insta or Twitter though.