Last active cell reference

[abc32]

Hello, I want to give reference to the last active cell of perticular sheet. As in, when I am creating a reference, I want that the range should be from one perticular cell to another perticular cell, and that cell should be offset x rows, x columns from the last active cell of the perticular worksheet.so I know how to move from the last active cell, how ever I want to know how to give reference to last active cell ? For example, I want to select range A1 to C3, so the second point C3 is selected based on the last active cell. Hence if the last active cell would be C5 then Offset(C5,-2) would give me C3, if the last active cell is D37, the end point of range would be different. How to find that last active cell using Excel formula ?