Add line with macro selected area

Giganews Newsgroups
Subject: Add line with macro selected area
Posted by:  doral
Date: Wed, 22 Aug 2007

For example I have a macro that sorts data from A1 to D5.  Is there a way for
this macro to pick up an extra line.  Say I copied row 1, and then pasted it
under row 1, so therefore, I would want the macro to sort from A1 to D6.  Is
there a way for the macro to automatically update itself, instead of me going
through all macros to update the selected range?  Thank you.

Replies