Leslie,

There is no standard InsertRowsAndFillFormulas macro, so posting the code
would help.

If you are game to try modifying it sight-unseen, then you could start the
macro with the line

Cells(65536, ActiveCell.Column).End(xlUp).Select

and that may work, since it selects the last filled cell in the current
column.

HTH,
Bernie
MS Excel MVP

"Leslie Barberie" wrote in message
...
I am using the macro mentioned in the subject. The problem is that it
will only insert a row if the active cell is in the last filled row. I want
the new row to be inserted after the last filled row, but there are multiple
users of this worksheet and there is no way of knowing where they will leave
the active cell. Is there a way for the active cell to be moved to the last
filled row when the worksheet is closed? That way the active cell would be
in the right place when the worksheet is opened and the new row would be
inserted in the right place. Or something like that?

Thanks.

Leslie Barberie