Skip to content

Instantly share code, notes, and snippets.

View quickstep25's full-sized avatar

Doug Hill quickstep25

4 followers · 9 following
View GitHub Profile
@quickstep25
quickstep25 / excel-delete-grouped-rows
Last active June 25, 2021 05:18
When exporting data from another source, such as SSRS, the groups will be maintained when opened up in Excel. This poses a problem when you have total and subtotal lines that were not created by Excel natively. So when you ungroup the rows in Excel,
_
@quickstep25
quickstep25 / find_word_frequency.vb
Last active July 17, 2021 22:56
Sub WordCount()
Dim Rng As Range, Dn As Range
Dim oMax As Double
Dim K As Variant
Dim Msg As String
Dim vWords As Variant
Dim myWord As Variant
Dim counter As Integer, WordCount As Integer
Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
@quickstep25
quickstep25 / strftime.txt
Created June 19, 2024 00:29 — forked from altamic/strftime.txt
STRFTIME
STRFTIME(3) BSD Library Functions Manual STRFTIME(3)
NAME
strftime, strftime_l -- format date and time
The conversion specifications are copied to the buffer after expansion as
follows:
%A is replaced by national representation of the full weekday name.
@quickstep25
quickstep25 / clearCredentials.ps1
Created April 10, 2025 01:43
PowerShell script to remove all the cached credentials in Windows Credential Manager.
$credentials = cmdkey /list
foreach ($line in $credentials) {
if ($line -match "Target: (.+)") {
$target = $Matches[1]
cmdkey /delete:$target
}
}