Renaming a cell name

  • Thread starter Thread starter Gary Paris
  • Start date Start date
G

Gary Paris

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

opening other workbooks at the same time 15
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
For Next If help 3
Using an array formula as a hyperlink cell reference 3
how do i calculate a running payoff amount? 2
[VBA] COMBOBOX SHOW WITH CONDITION 4
Adding to a "list sheet names" macro ... 2

Back
Top