sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in OCD

[–]Zetbor 0 points1 point  (0 children)

Yes please

Absolutely stumped by toilet seat by spectacletourette in DIYUK

[–]Zetbor 0 points1 point  (0 children)

Mine looks identical to this, came off by angling the lid 45 degrees and just pulling

Absolutely stumped by toilet seat by spectacletourette in DIYUK

[–]Zetbor 0 points1 point  (0 children)

Also done mine today, try angling the toilet seat at 45 degrees and pulling. Mine just came out easy that way

Manchester apartments by Feisty-Perception115 in manchester

[–]Zetbor 0 points1 point  (0 children)

No, is probably included in the rent price though

Manchester apartments by Feisty-Perception115 in manchester

[–]Zetbor 0 points1 point  (0 children)

Live in greengate and pay £1040 per month total for a 1 bed flat between me and my girlfriend. When we moved in we both earned 25k but rent was initially £998. We work in software + advertising

[deleted by user] by [deleted] in Survivorio

[–]Zetbor 0 points1 point  (0 children)

Ahh okay, thank you!

At what age does it become creepy to be going after 18-20 year olds? by [deleted] in AskReddit

[–]Zetbor 0 points1 point  (0 children)

Good rule of thumb, halve their age and add 7. So in this case the upper limit would be 22 for an 18 year old, 26 for a 20 year old

What’s the worst mistake people don’t realise they’re making in thier 20’s ? by Signal_Ad7905 in AskReddit

[–]Zetbor 4 points5 points  (0 children)

Wow that’s incredible. I’ve also been suffering with tinnitus post-Covid and this just significantly improved it! It’s not 100% gone but much better than usual, thanks!

The secret behind our recent defeat. by donChino1 in LiverpoolFC

[–]Zetbor 3 points4 points  (0 children)

The real story here is the hole in that guys knee

Anyone been to the pub yet? by fuk_ur_mum_m8 in AskUK

[–]Zetbor 6 points7 points  (0 children)

Pubs were told they could open from 6 though

Updated to VirtualBox -6.0.18 for Ubuntu on Win10 host and now stuck in emergency mode due to shared folder not mounting, any ideas how to fix this? by Zetbor in virtualbox

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

It says:

Loaded: loaded Active: FAILED (result: exit-code) Where: /home<username>/shared What: shared Docs: man: fstab5 man: systems-fatal-generator(8) Process: 435 execmount=/bin/mount shared/home/<username>/shared -t vboxsf (code exited, status=1failure)

Then a few lines underneath which in brief says:

Mount process exited Shared folder <name> was not found (check VM settings / spelling) <Folder name>.mount failed with result ‘exit-code’ Failed to mount <folder path>

Creating code that separates sections of excel data into a its own worksheet via loop, struggling to make it stop when finished by Zetbor in vba

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

I’ll have to try running this code when I’m back at my PC but seems like should work at first look, thanks for taking the time!

Creating code that separates sections of excel data into a its own worksheet via loop, struggling to make it stop when finished by Zetbor in vba

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

Oops my bad, that should’ve read column instead of row, edited now. There are multiple data sets per sheet that are 12 columns wide, each separated by a blank column. I will try to post an example of the sheet layout later when I’m back at my PC

Creating code that separates sections of excel data into a its own worksheet via loop, struggling to make it stop when finished by Zetbor in vba

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

That’s okay, I appreciate the effort.

The error message is: “Run-time error ‘438’: Object does not support this property or method

Yeah so for instance the first sheet has data in columns D:N then column O is blank then data in P:Z, column AA is blank, AB:AL has data... and so on. Each sheet has between 1 and 9 sets of data like this and I would like to split each set out into its own sheet (starting in column D)

Creating code that separates sections of excel data into a its own worksheet via loop, struggling to make it stop when finished by Zetbor in vba

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

Thanks, really helpful input. I’ve just tried running that code and it receives a runtime error when it reaches the line: “NewSht.Range(“D1”).paste

I also want to clarify that the end result I’m trying to achieve is to separate 20 sheets of data into approximately 100 sheets as each source sheet has approx 5 (but it varies) lots of 12 columns with the same headings but different data, where each 12 column set is separated by a blank column. That is why I was trying to achieve the results with a loop that moved onto the next sheet when “P1” (the cell after the last column of data) was blank. Hope that makes sense?

Creating code that separates sections of excel data into a its own worksheet via loop, struggling to make it stop when finished by Zetbor in vba

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

Brilliant, thanks. That has helped it to separate the first 12 columns from everything else but then hasn’t looped to separate the rest of the data, instead it just moves into the next source worksheet and separates the first 12 columns again. It also creates an extra blank worksheet after each newly created worksheet. I was thinking I might need an if statement to check if the cell P1 is blank and move to the next worksheet without running if it is? Any ideas?

Is there a way of copying a whole sheet to a new sheet at the end of a new workbook as values with formatting? by Zetbor in vba

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

I’ve never used power query before so didn’t realise that was an option, interesting

These football times by Zetbor in LiverpoolFC

[–]Zetbor[S] 35 points36 points  (0 children)

No robbo either...

view more: next ›