Excel macro insert row below the current cell

This is a tweak that saves me some time. Sub InsertRowBelow() ' ' InsertRow Macro ' ' Keyboard Shortcut: Ctrl+Shift+I ' Dim rw rw = Selection.Row 'get the original row col = Selection.Column 'get the original column Rows(rw + 1 & ":" & rw + 1 ).Select 'select the row below Selection.Insert...

October 31st, 2012 by B.Harding 

Automatically reboot an unresponsive Windows Server

My servers are leased so if anything goes wrong and a reboot is needed I have to wait for my provider to preform it. In this post we will create a vb Script that pings an IP address and reboots if it can’t see it. We will simply run it on a timer using the command scheduler. Here is the script: Option Explicit dim strHost ‘The ip address you want to monitor strHost=”111.222.333.444″ if...

February 5th, 2009 by B.Harding