excel vba get relative address of active cell code example

Example: vba get relative cell address

myAddress = Worksheets("Sheet1").Cells(1, 2).Address(False, False)

'myAddress is now A1