Skip to content

Instantly share code, notes, and snippets.

View jaykilleen's full-sized avatar

Jay Killeen jaykilleen

View GitHub Profile
@jaykilleen
jaykilleen / gist:cce6afd13d2bd2a8c70b
Last active August 29, 2015 14:17
Excel VBA Find Last Row as get_last_row function
'Just copy the function below into a new module
'I usually call this module 'functions'
'You can then call anywhere in your scripts `get_last_row(ThisWorkbook.Sheets("sheet_1"), 1)
'It will then find you the last row of column A
`Change the interger for the second argument to use any other column
`checkout https://gist.github.com/jaykilleen/892d0f0eed87b9f8e6b0 for other functions that I like to add into my 'functions' module.
Option Explicit
Function get_last_row(sheetname As String, column_number As Integer) As Long
@jaykilleen
jaykilleen / devise_registrations_new.html.erb
Created January 20, 2015 04:23
Bootstrapping Devise New Registration View on Rails 4.2.0 with Bootstrap 3
<div class="container">
<div class="row">
<div class="col-sm-4 col-sm-offset-4">
<div class="light-well">
<h2 class="page-header text-center">Sign Up</h2>
<%= form_for resource, as: resource_name, url: registration_path(resource_name),
html: { class: "form-horizontal center"} do |f| %>
@jaykilleen
jaykilleen / devise_sessions_new.html.erb
Created January 20, 2015 04:21
Bootstrapping Devise New Session View on Rails 4.2.0 with Bootstrap 3
<div class="container">
<div class="row">
<div class="col-sm-4 col-sm-offset-4">
<div class="light-well">
<h2 class="page-header text-center">Welcome Back!</h2>
<%= form_for resource, as: resource_name, url: session_path(resource_name),
html: { class: "form-horizontal center"} do |f| %>
<div class="form-group">