Skip to content

Instantly share code, notes, and snippets.

@eltioska
eltioska / check_named_range_exists.vbs
Last active August 16, 2019 07:22
check if named range exists #excel #vba
' Solution - check if named range exists
'
' rather than checking if named range exists,
' initialise a string, add all existing named ranges' names to it,
' and then check if the required named range is in the string:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim sList As String
@eltioska
eltioska / 0_reuse_code.js
Last active August 29, 2015 14:14
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@eltioska
eltioska / CSS image replacement.css
Last active March 15, 2018 18:18
CSS: Image Replacement #css
.ir {
border:0;
font: 0/0 a;
text-shadow: none;
color: transparent;
background-color: transparent;
}
@eltioska
eltioska / HTML starter.html
Last active July 16, 2020 00:44
HTML: Starting Template #html
<!doctype html>
<head>
<meta charset=utf-8>
<title></title>
</head>
<body>
<script src="ttps://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
</body>
</html>