I'm trying to get VBA to remember a cell address so that I can return to it after entering data below that row. For example, if I have a table full of data and then add a number of rows of data directly below it, I want to know where the new data starts so that I can adjust accordingly before I sort the entire table and save it ready for the next addition of new data.
Thought it might have gone a little like this but I'm wrong.
Range("A65001").Value = Selection.Address()
Dim Address As Variant
Address = Range("A65001").Value
Please can someone help me.