libRanges (Excel Range Functions)

Public Sub goDown( r  As  Range )

Move range r down by one row

goDown r

Public Sub goRight( r  As  Range )

Move range r right by one row

goRight r

Public Sub goUp( r  As  Range )

Move range r up by one row

goUp r

Public Sub goLeft( r  As  Range )

Move range r left by one row

goLeft r

Public Sub removeRow( r  As  Range )

Removes row r without changing r’s address

removeRow r

Public Function insertRowAfter( r  As  Range ) As Range

Inserts a row after the given cell’s row and returns the new row

set newRow=insertRowAfter(currentRow)

Inserts a row before the given cell’s row and returns the new row

set newRow=insertRowBefore(currentRow)