Skip to content

Instantly share code, notes, and snippets.

View NixonInnes's full-sized avatar
🐇

James Innes NixonInnes

🐇
  • Aberdeen, UK
View GitHub Profile
@NixonInnes
NixonInnes / [Excel] CAT
Created May 20, 2015 10:15
[Excel] Concatenate cells with a delimiting character between cells
Function CAT(cell_range As range, delim As String) As String
Dim CAT_iter As String
Dim iter As Integer
iter = 1
For Each cell In cell_range
If iter = cell_range.Count Then
CAT_iter = CAT_iter & cell.Value
Else
CAT_iter = CAT_iter & cell.Value & delim
@NixonInnes
NixonInnes / [Excel] ANNA_MAP
Created May 20, 2015 10:29
[Excel] Convert a string into an alphabet (A) & numeric (N) map
Function ANNA_MAP(anna_text As String) As String
Dim map As String
Dim RegExp As Object
Set RegExp = CreateObject("VBScript.RegExp")
Dim aPattern As String
Dim nPattern As String
Dim cPattern As String
aPattern = "[a-zA-Z]"
nPattern = "[0-9]"
@NixonInnes
NixonInnes / [Excel] CombineSheets
Created May 20, 2015 10:32
[Excel] Combines all Worksheets into a new Worksheet
Sub CombineSheets()
Dim I As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add
Sheets(1).Name = "Combined"
Sheets(2).range("A1").EntireRow.Select
Selection.Copy Destination:=Sheets(1).range("A1")
@NixonInnes
NixonInnes / gist:0581aa33759d6b225f93
Last active August 29, 2015 14:24
GW2 API Testing
# -*- coding: utf-8 -*-
"""
Created on Fri Jul 3 11:09:36 2015
@author: James.Innes
"""
import requests
import json
@NixonInnes
NixonInnes / DiabloIII.ahk
Created September 6, 2017 20:29
Diablo III Autocast Autohotkey Script
; This is an AutoHotKey script designed to be used with Diablo III
; Pressing F1 will constantly activate skill 1, F2 will activate skill 2, F3 for 3, and F4 for 4
; The keys are togglable.
Thread, interrupt, 0
togF1 := 0
$F1::
togF1 := !togF1
if (togF1) {