Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

The Offset method can also use negative arguments A negative row offset refers to a row above the range A negative column offset ref

Sub offsetNe()     range("C2").offset(-1, -2).Select End Sub