how do i maintain named range addressing after deleting row?
 

i am using Excel 2000 and xp home for a platform. I am writng a vba of which
part of the automation is to first copy the info i want deleted on one sheet
and putting it into another sheet in the same workbook. Then the procedure is
to delete the rows that hae that same information on them using named ranges
to keep track of the various info. The problem comes in when i delete the
rows, the assigned addresses for the ranges are being adjusted so after a
while I end up with no range at all to work from. How do i stop this from
happening?