I think you can't create a range name with a cell address as name. The '$' isn't allowed in range names. I think you can't create a range name with a cell address as name. The '$' isn't allowed in range names.