If you want myLastCell to refer to the previous row, just do this:

myLastCell = Cells(myLastRow - 1, myLastColumn).Address

or you can make myLastRow equal to the row you need (if you need it for
nothing else) by:

myLastRow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row - 1