Resize Merged Excel Cells – VBA

[vb] Dim NewRwHt As Single Dim cWdth As Single, MrgeWdth As Single Dim c As Range, cc As Range Dim ma As Range With Target If .MergeCells And .WrapText Then Set c = Target.Cells(1, 1) cWdth = c.ColumnWidth Set ma = c.MergeArea For Each cc In ma.Cells ¬†¬†¬†¬†¬†¬†¬†¬† MrgeWdth = MrgeWdth + cc.ColumnWidth Next Application.ScreenUpdating[…]

Posted in VBA

Remote desktop connection shortcut

The Windows Remote Desktop is a built-in tool that lets you take control of a computer¬†over a network connection. It is useful for accessing computers that are not sitting in front of you, and it‚Äôs something that I use quite frequently. I‚Äôm typically connecting to several computers every day using Remote Desktop, and it finally[…]