Hi GS,

I thought about adding a "name," but the problem is that this macro could be
run on several worksheets within the same workbook, so I don't know how the
naming scheme would work in that situation without adjusting the macro for
each sheet.

Thanks
Kim



"GS" wrote in message
...
Hi Kimberley,

Just a suggestion: - You could create a defined name for the range of
source data. If users add or delete rows between the first and last row,
it
adjusts itself. To handle users adding rows after the last row, make the
definition dynamic.

You'll find more info he

http://www.contextures.com/xlNames01.html#Dynamic

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

HTH
Regards,
GS