I would 1st ask why you have a need to give alternate rows a range name? If you are trying to add data on alternate rows, if the row headings have a similar wording, you may be able to use something like SUMIF()