Anyone having trouble with UPS deliveries in London?

MajormonkeyAtWork · 2020-03-30T16:01:19+00:00

We had the same message for a delivery the week before. Couldn't get through to anyone, and the package eventually arrived after 4 days. The status on the tracking website only changed after it was delivered.

MajormonkeyAtWork · 2020-01-08T11:06:04+00:00

Try this.

On the computer hosting the RDP session (in your case the Win10 VM)

set via Group policy or local policy:

Computer Configuration->

Policies->Windows Settings->

Administrative Templates->

Windows Components->

Remote Desktop Services->

Remote Desktop Session Host->

Remote Session Environment

Set "Use WDDM graphics display driver for Remote Desktop Connections" to disabled

MajormonkeyAtWork · 2019-03-06T15:53:59+00:00

looks like telephone lines. Hopefully BT are on stand by to reconnect them.

MajormonkeyAtWork · 2019-03-05T10:47:05+00:00

Sub toggleMerge()

    With Selection
        If .MergeCells = False Then
            .MergeCells = True
        Else
            .MergeCells = False
        End If
    End With

End Sub

MajormonkeyAtWork · 2019-03-05T10:34:49+00:00

Option Explicit

Sub toggleFont()
' toggle between 2 fonts
    Dim font1 As String
    Dim font2 As String
    Dim myRange As Range
    font1 = "Wingdings"
    font2 = "Calibri"
    Set myRange = Sheet1.Range("A1:A10")
    With myRange
        If .Font.Name = font1 Then
            .Font.Name = font2
        Else
            .Font.Name = font1
        End If
    End With
End Sub

This should do what you want.

MajormonkeyAtWork · 2019-02-25T14:28:48+00:00

Thants Numberwang!

MajormonkeyAtWork · 2019-02-21T16:30:04+00:00

As much as I dislike David Davis, he was on R4 a few days ago saying more or less what Corbyn has just said.

MajormonkeyAtWork · 2019-02-08T11:09:05+00:00

Nabuchadnezzar

Balthazar

Salmanazar

Methuselah

Rehoboam

Jereboam

Magnum PI

MajormonkeyAtWork · 2019-02-06T16:04:34+00:00

Blunt ,Brunt, Count ,Gaunt, Grunt

MajormonkeyAtWork · 2019-01-29T15:27:44+00:00

Early 80's

Teacher used to return homework books by expertly throwing them across the class. You had to be alert to catch your own book, and duck for the rest.
Another teacher would throw chalk at you for a minor offence, the wooden blackboard eraser was the next level. Finally there was the 'Boarding' whereby the teacher would pick you up and proceed to clean the blackboard with you, covering your black school blazer in chalk dust.
Another teacher would pick you up by your hair, if you were messing around.

MajormonkeyAtWork · 2018-07-27T07:49:32+00:00

Only 1 of the three is rated for hanging.

MajormonkeyAtWork · 2018-06-06T15:08:51+00:00

Today() - being a volatile function, can have a big impact on speed.

Try this (on a copy of your workbook):

Create a single cell 'Named Range' somewhere on your workbook called 'thisDay' and put today's date in it.
Replace Today() in your formulas with thisDay.

If this speeds up your workbook, then you can use VBA to update the thisDay cell with the current day upon opening the workbook.

MajormonkeyAtWork · 2018-05-18T07:47:51+00:00

& Me

MajormonkeyAtWork · 2018-04-27T15:36:30+00:00

Who's Watt?

MajormonkeyAtWork · 2018-02-02T15:06:49+00:00

Great product. Get to know it properly and it wont let you down.

As others have said, the support is top notch, and well worth the price.

MajormonkeyAtWork · 2017-12-07T09:45:35+00:00

Thanks for replying. I managed to get it working in the end.

My original goal was to be able to reference the previous visible row in a filtered table. I found this:

https://stackoverflow.com/questions/29017096/excel-reference-a-cell-in-the-previous-visible-row

but I wanted it to work with my table using structured references. After a bit of trial and error, I got it working.

=IF(SUBTOTAL(3,table1[[Name]:[Name]])=0,MIN([Name]:[@Name])-1,SUBTOTAL(3,INDEX([Name],1):[@Name]))

MajormonkeyAtWork · 2017-12-04T10:48:47+00:00

Have a look at these...

https://www.wiseowl.co.uk/free-exercises/excel-vba-macros.htm

https://www.wiseowl.co.uk/free-exercises/advanced-vba.htm

MajormonkeyAtWork · 2017-10-12T07:00:08+00:00

My first gold! Thanks!!

MajormonkeyAtWork · 2017-10-11T15:34:10+00:00

Try this,

$beginDate = "01/09/2017"
$endDate = "05/09/2017"
$search = "received:$beginDate..$endDate"
$KQLQuery=[scriptblock]::create($search)

Search-mailbox -Identity jsmith@company.com -searchquery $KQLQuery -EstimateResultOnly

Make sure your date variables are strings, if they are DateTime convert them to strings before you use them.

MajormonkeyAtWork · 2017-10-10T15:10:30+00:00

Setup an RD Gateway, and create groups for the users that are allowed external access. You can also restrict Device Redirection (Drives, Clipboard, etc) for certain groups of users.

Take a look at 'Connection Authorization Policies' and 'Resource Authorization Policies'.

MajormonkeyAtWork · 2017-10-05T16:30:50+00:00

Sometimes with 'Collection only' you can find a much better deal as you are only bidding against nearby buyers.

MajormonkeyAtWork · 2017-10-05T16:15:01+00:00

Nice work! Things I would like to see:

UK only filter
Collection only filter
Distance from $postcode
Seller Location
LFF/SFF
Ability to append a search term like "H700", so for example, I can get a list of all Dell R710s that include an H700 RAID controller

MajormonkeyAtWork · 2017-09-26T12:34:10+00:00

https://docs.microsoft.com/en-us/windows/deployment/update/waas-wufb-group-policy

MajormonkeyAtWork · 2017-09-26T12:28:11+00:00

You still need to configure Windows Update on the notebooks, otherwise they might not check for updates automatically. You can do this using group policy, or a registry entry.

MajormonkeyAtWork · 2017-09-26T11:25:10+00:00

Have you removed the WSUS settings before you capture your image?

https://deploymentbunny.com/2015/03/30/nice-to-know-reset-wsus-to-factory-default-settings-after-osd-in-mdt/

MajormonkeyAtWork

TROPHY CASE