Dear Bagia

Insert the new row within the range.
OR
Leave the last row blank and include in the RANK range. Everytime insert a
row keeping the cursor in this blank row..

--
If this post helps click Yes
---------------
Jacob Skaria


"Bagia" wrote:

Hello,

How would I include a new row of data to be included in my Rank function
automatically w/o having to manually edit the function to include the new
inserted row? Is there a way?