Microsoft Excel Training Videos

You can refer to Excel cells relative to other worksheet Excel cells using Excel macro. A common way to work with an Excel cell relative to another cell in Microsoft Excel is to use the Offset property. In the following example, the contents of the Excel cell that's in the same row and two columns over from the active cell on the active Excel worksheet are formatted as double-underlined.
Sub UnderlineDouble()
ActiveCell.Offset(0, 2).Font.Underline = xlDouble
End Sub

Further resources Excel Cell References. Relative and Absolute Cell References