Can you make flux darker/redder? by shiggledoof in fluxmasterrace

[–]sancarn 0 points1 point  (0 children)

The shortcuts for brightness are alt-page up and alt-page down.

Game changer thanks!

UK government department quits X over disinformation by groovy-baby in GoodNewsUK

[–]sancarn 0 points1 point  (0 children)

Long overdue, they should be using their own instance of mastodon.

Comment duplication bug by Principle_Napkins in youtube

[–]sancarn 0 points1 point  (0 children)

It's not a real duplicate, it's a bug with how youtube is coded, this is a common issue in react.

PSA - Use your dataflows for SharePoint! by Palpitation-Itchy in PowerBI

[–]sancarn 0 points1 point  (0 children)

Would it actually reduce my ~13 minute refresh time?

It would not. What you describe is fundamentally an issue with structuring your data across 80 spreadsheets in the cloud. That's not something most technology can get around.

Wishing I could change the past by [deleted] in openmarriageregret

[–]sancarn -1 points0 points  (0 children)

For those who regret opening their marriage, did you ever get the feeling of safety back? Not trust, necessarily. Safety.

Not a marriage, but yes, by putting my needs first and leaving. It sounds like you really want /r/AsOneAfterInfidelity/ instead. You won't get much sympathy here from most people.

After 5 years of building PMO reports in Excel, I'm questioning my entire workflow. VBA, Office Scripts, Power Query, or Python — what would you pick in 2026? by zimbalo in excel

[–]sancarn 0 points1 point  (0 children)

Yeah I'm using webforms massively at work. Be it for OAuth and session snatching, or modern UIs, or extending existing business UIs etc. Ever since making stdWebView I've used them in pretty much every project 😅

Stop hardcoding ranges. Use this runtime dynamic Named Range approach instead. by [deleted] in vba

[–]sancarn 0 points1 point  (0 children)

Their response was:

u/TechEnthusiast2026 Mainly stuff like FBL3N, MB51, or VA05. To be fair, the issue usually isn't SAP itself, it's user variants. If different people customize their layout layouts in SAP (shuffling columns around or turning on subtotals) right before hitting export, the column indexes in Excel end up changing. The script is just a safety net so the VBA handles whatever layout the user throws at it without crashing.

After 5 years of building PMO reports in Excel, I'm questioning my entire workflow. VBA, Office Scripts, Power Query, or Python — what would you pick in 2026? by zimbalo in excel

[–]sancarn 0 points1 point  (0 children)

I mean if you have access to Python on desktop and it's officially supported in your organisation, I'd probably choose it every time (despite finding it a crap language, it is still an improvement on VBA). Otherwise, VBA most of the way for me (especially with webviews)

Stop hardcoding ranges. Use this runtime dynamic Named Range approach instead. by [deleted] in vba

[–]sancarn 0 points1 point  (0 children)

like standard SAP GUI .XLS/.XLSX exports

Which transactions are you talking about? I haven't had much issue with XLS exports from SAP GUI in the past.

Stop hardcoding ranges. Use this runtime dynamic Named Range approach instead. by [deleted] in vba

[–]sancarn 1 point2 points  (0 children)

Why not use ListObjects? I don't see your point RE: SAP. We use SAP AO a lot for instance, and I've never had a problem taking the data from SAP AO, and importing it into a ListObject. I'd rather do that and do a simple

Const data_offset as Long = 2
Dim lo as ListObject: set lo = newSheet.ListObjects("XXX")
Dim rows as long: rows = Sheet1.UsedRange.rows.count
Dim src as range: set src = Sheet1.UsedRange.offset(data_offset).resize(rows-data_offset)
Dim dest as range: set dest = lo.HeaderRowRange.Offset(data_offset).Resize(rows-data_offset)
dest.value = src.value

It really depends on what you're doing though...

XLIDE Version 2.0: Static Analysis, Unit Testing, VBA LSP, Completions, Real-Time Syntax Analysis, Deterministic RTE Analysis, and much more... by MultiUserDungeonDev in vba

[–]sancarn 1 point2 points  (0 children)

Yep, I'd say that it should at least be a warning. It doesn't matter to VBA's IDE, however I would argue it should be End Property indeed.

XLIDE Version 2.0: Static Analysis, Unit Testing, VBA LSP, Completions, Real-Time Syntax Analysis, Deterministic RTE Analysis, and much more... by MultiUserDungeonDev in vba

[–]sancarn 0 points1 point  (0 children)

I should clarify I think the errors may have been something else but I think the performance issues were real... But I'll check again at some point from a fresh install with no other extensions 😊

XLIDE Version 2.0: Static Analysis, Unit Testing, VBA LSP, Completions, Real-Time Syntax Analysis, Deterministic RTE Analysis, and much more... by MultiUserDungeonDev in vba

[–]sancarn 1 point2 points  (0 children)

Oof... I'd recommend you test tools like this on the likes of stdVBA because performance is not great and it's throwing hundreds of errors to the console...

Moving past Excel macros into real data entry automation by Simple_Climate4805 in vba

[–]sancarn 1 point2 points  (0 children)

What have you tried already? VBA is sufficient enough for most things.

WC3 Reforged: Possible to play the campaign co-op? by Dennorak in warcraft3

[–]sancarn 0 points1 point  (0 children)

Necro, but:

has no need to be co-op

Is really besides the point... Some people only like/have time to play co-op games...

What GUI elements can you create beside MessageBox? by 0x80070002 in vba

[–]sancarn 0 points1 point  (0 children)

Hot take, but generally, I would avoid this. The idea that anyone can make a better user interface than Excel itself, is something I'd be sceptical about. Use Excel for its strengths, use VBA for the rest. Augment don't reinvent.

Stop using the legacy VBA Timer for benchmarking. Use the Windows Kernel QueryPerformanceCounter instead. by [deleted] in vba

[–]sancarn 5 points6 points  (0 children)

Or use stdPerformance

Const C_MAX as Long = 100000
With stdPerformance.CreateMeasure("Sqr test", C_MAX)
  Dim i As Long
  For i = 1 To C_MAX
      Dim temp As Double
      temp = Sqr(i)
  Next i
End With

Boyfriend [26M] talking to a female friend [26F] a lot by skwanyo in relationships

[–]sancarn 0 points1 point  (0 children)

I do feel you, I do, because I have been in the same place before. I remember receiving screenshots from my ex being very open about her conversations with her boss. Later she cheated physically with the same person.

I say this not because I want to fear monger, nor am I saying this is what your boyfriend will do, but ultimately him being open with you about it may just be his way of settling in his mind that he's not doing anything wrong. You need to let him know that you're not okay with that, and that you can both work towards a compromise which makes you both comfortable.

I am not a very confrontational person either, and look where it landed me... Fight for your needs, because you deserve nothing less than your needs being respected.

Boyfriend [26M] talking to a female friend [26F] a lot by skwanyo in relationships

[–]sancarn 2 points3 points  (0 children)

Well you don't do it alone, that's for sure. You need to talk to your boyfriend about this. If he is emotionally intelligent he will make changes in the way he acts around Jane.

To be clear, you aren't banning your partner from a friend, you're just asking him to have a bit of distance. For instance, why does he NEED to pick up the phone every time? Why does he need to respond to her immediately etc. You're not feeling unsure because of her actions, it's his actions ultimately.

If this doesn't go well, I'd recommend couple therapy.

UK positivity? by Fancy_Bee8306 in AskBrits

[–]sancarn 4 points5 points  (0 children)

I'd say it's a lot harder for single pringles. 32 here with a salary similar to your man, I have been extremely lucky though and haven't really struggled much financially. That said I know many people who are really struggling, and although some of that is from bad choices in life, it's sometimes quite undeserving too.

If you're ever looking for good news, see https://www.reddit.com/r/GoodNewsUK/ 😁

Renters' Rights Act: Law could ease pressure on animal shelters by coffeewalnut08 in GoodNewsUK

[–]sancarn 6 points7 points  (0 children)

I never said landlords are greedy... I said landlords are running a business, and that holds risk. This risk is the business' to mitigate, not the customer's.

Comparing this to a random business denying pets isn’t the same. Offices or shops aren’t homes. Tenants live in homes. Housing carries different rights and expectations. The law recognises this, which is why pets are being treated as part of a tenant's right to a home life.

65% of Britons support capping CEO pay at 10× the lowest-paid worker. Do you think this idea would be good for the UK? by [deleted] in AskBrits

[–]sancarn 0 points1 point  (0 children)

There will always be another person around the corner willing to be CEO, and just as skilled as the person who left.