May have been better if you had posed some of yout code but try something
like:

ActiveCell.End(xlUp).Offset(1, 0).Select

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MechEng" wrote in message
...
I am running a macro to add rows or remove rows assigned to a form button.
The problem is if the active cell is moved from the last blank row the
marco
won't run.

Is it possible to have the macro alway return the cursor to the required
active cell before it runs?