Renaming a cell name

I have a cell that is named "payment". On another sheet, there are multiple
cells that reference "payment". Is there a way to rename "payment" and
change every occurence of it in the workbook?

Thanks,

Gary

to change what cell it refers to

worksheets("Sheet2").Range("B9").Name = "payment"

to change the name use Edit=>Replace


--
Regards,
Tom Ogilvy

"Gary Paris" <[email protected]> wrote in message
news:[email protected]...
> I have a cell that is named "payment". On another sheet, there are
multiple
> cells that reference "payment". Is there a way to rename "payment" and
> change every occurence of it in the workbook?
>
> Thanks,
>
> Gary
>
>