View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leslie Barberie Leslie Barberie is offline
external usenet poster
 
Posts: 10
Default InsertRowsAndFillFormulas

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 Barberi