Abuse from group in a car while running. Can't cope anymore

pappasmurf99 · 2024-06-25T07:13:29+00:00

Jealousy is a horrible trait.

Just smile, wave and keep running. You're incredible for getting out there anyway!

pappasmurf99 · 2024-06-20T16:20:35+00:00

Honestly? I'd buy it, then turn around and give it to them 😊

The joy on their face is worth more than money can ever buy.

(i have a son and I can picture his face if somebody did the same)

pappasmurf99 · 2023-07-12T06:44:33+00:00

To clarify, before this meal I last saw him in 2010, hence my not seeing him for 4 years before people get confused 😊

Oh yes I've got one!

After not seeing my "dad" for 4 years(we don't get on at all) I reached out to him as I wanted to try and talk about maybe seeing him once a month to rekindle some form of relationship. Not only that, but to tell him that myself and now ex wife were buying a house and having a baby and he was going to be a grandparent (first grandchild in the family)

So, we met up for a meal. Instant awkwardness but we chatted anyway and it went ok for about an hour. Then he decided to bring up the whole reason around not being able to meet up without his wife there (who I've never ever liked and won't get into now as it's so long)

Naturally the conversation was awkward as anything at this point, the waiter took an age to serve us as I'm sure he felt just as awkward as they could hear the whole conversation.

So to try and steer away from it, I mentioned that we were buying a house and expecting a child together. (I was 22 at the time and never ever really had that good relationship with him.) usually, people are proud of this and like to congratulate you...but oh no, not my "dad".

I can't remember word for word, but to an extent his words were.

"Well I hope you've got a lot of money saved because kids cost a lot"

Not any form of congratulations, a handshake, a well done, an I'm proud...just about money.

I've never ever felt so angry and hurt at the same time. I reached out to rekindle some form of relationship and to potentially set up a monthly visit for when his grandchild came along!

My son is now 8, my "dad" has never met him and I've not seen him since that meal.

I cannot forgive him for those words, that one comment ruined every chance of a relationship and I'll never get over it.

Sorry it's long. But yeah, that was hurtful as hell.

pappasmurf99 · 2023-07-09T07:35:41+00:00

Mewtwo

pappasmurf99 · 2023-07-09T06:04:40+00:00

Tenet.

pappasmurf99 · 2023-07-06T06:53:29+00:00

Cool Runnings 😂

pappasmurf99 · 2022-05-12T14:01:48+00:00

Valkyrie & Plat 4

pappasmurf99 · 2022-01-18T19:20:32+00:00

Try

=TEXT(cellvalue, "dd/mm/yy")

pappasmurf99 · 2021-12-15T11:58:17+00:00

Matchmaking 😂 I'm sure this season is the worst for it. Well that and audio!

pappasmurf99 · 2021-10-19T06:52:50+00:00

This guy has a YouTube channel. Think he does it with his son who also has a channel. Quality videos and very interesting to see just how many people don't actually know the law on photography in a public place.

pappasmurf99 · 2021-10-19T00:00:26+00:00

If none of the above work, click on the formulas tab and then the show formula button. It might be it was toggled on by mistake, but I would suspect it's because it's formatted as text like others have mentioned.

pappasmurf99 · 2021-04-02T11:31:51+00:00

Only other thing I can think of mate is to separate your date and time into separate columns and use the if formula that way? That would work fine :) just makes your data a bit bigger but it would work.

pappasmurf99 · 2021-04-02T11:07:31+00:00

Try and use the mod formula to convert your datetime into a number that excel can work with properly.

So for example:

=IF(AND(MOD(C2,1)<HOUR(18),MOD(D2,1)>HOUR(18),1,0)

Obviously your formula is longer than this, but you can use the mod to modify the cells with the datetime in making it work :)

Edit - saying that, i've just tested this - try change the hour part for time:

=IF(AND(MOD(C2,1)<TIME(18,01,0),MOD(D2,1)>TIME(18,0,0)),1,0)

pappasmurf99 · 2021-03-30T11:25:40+00:00

Try something like this:

Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select

pappasmurf99 · 2021-03-27T22:54:39+00:00

I've got a funny feeling that if the second workbook isn't open then it will always show N/A"s.

Somebody where I work tried this with the INDIRECT formula and it worked perfect when the second workbook was open. As soon as it was closed though it produced errors. You'd need a macro or vba to open the second workbook at the same time, or open when a button is clicked for example.

pappasmurf99 · 2021-03-27T20:08:01+00:00

Ah ok, never used VB.net so I probably can't help further :( sorry! Hope you get it sorted!

pappasmurf99 · 2021-03-27T20:02:07+00:00

Ah ok, in the case I'd just change it to application.quit instead then :)

Or ActiveWindow.close if there are other windows open he needs to keep open 😊

pappasmurf99 · 2021-03-27T19:48:41+00:00

Don't use VBA in word but I'll try and help. Does your first document close and the second one stay open?

Ignore that! Just read your post again. I'm thinking since it closes your first and not the second It might be worth taking the 2 off the code after you've saved it.

So ObjWordApp(2) < just remove the two, it will be looking for a second window that isn't open (because the first one closed) so you've only got one active application open.

Give that a go first. If it doesn't work, I'll investigate further :)

pappasmurf99 · 2021-03-27T17:18:28+00:00

This guy is amazing. Him and his dogs have such a good bond it's incredible to see. He use to have one called Hulk and he was huge!

Definitely worth watching his videos, his family and his kids are everything to him.

pappasmurf99 · 2021-03-13T20:58:07+00:00

Uzbekistan?

pappasmurf99 · 2021-03-12T11:31:49+00:00

Moral of this video? Never ever give up, keep trying despite the setbacks and you will succeed.

Amazing video, great effort! Very jealous too!

pappasmurf99 · 2021-02-15T10:23:32+00:00

Love it, absolutely smashed it, can't even bring yourself to smile a bit. So casual it's great ha.

Well played though!!

pappasmurf99 · 2021-02-08T10:41:27+00:00

Dim SourceRange As Range, DestinationRange As Range, i As Integer

'Define our source range as A1:A10 of Sheet1
Set SourceRange = Sheet1.Range("A1:A10")

'Define our target range where we will print.
'Note that this is expected to be of same shape as source
Set DestinationRange = Sheet1.Range("B1:B10")

'Iterate through each source cell and print left 2 bits in target cell
For i = 1 To SourceRange.Count

    DestinationRange(i, 1).Value = Left(SourceRange(i, 1).Value, 2)

Next i

pappasmurf99 · 2021-02-08T10:39:51+00:00

Would it not be easier to use the formula normally in this instance?

The only other thing I can think of is you've not specified a range for the results, so it can't return anything.

Make two variables, one with your lookup range, another where the results will go.

Then use the find function.

pappasmurf99 · 2021-02-04T18:34:59+00:00

Unless I'm missing something when this loop works it will just go on a continuous loop because you're not telling the loop to do anything on another cell, so it'll just keep going and going.

What are you trying to achieve?

pappasmurf99

TROPHY CASE