change named ranges

  1. D

    Change Range Names with VBA Macro.

    I am trying to change some range names on different sheets so I can do this faster than doing it manually. I have about 30 ranges for each sheet and they are all named Prop___ i.e. Prop1, Prop2, PropLAE1, PropSUB1... and I want to change them to CovA___. I need to do this for 5 different sheets...
  2. D

    Change name of named range across VBA code

    I've inherited some VBA code that makes use of named ranges in a shorthand way where "xTodaysPrice" is a named range of one cell: If iCol = [xTodaysPrice].Column Then...The name needs to be changed now to something else, e.g. "xAvgPrice". Besides using search/replace across the whole code is...
  3. D

    Add Suffix To All Named Ranges

    Hi, I've got two worksheets from different files i need to merge into one workbook....the problem being they both share a lot of the same named ranges (because I'm not very clever with my names). I'm wondering if there is a way anybody knows of to add a suffix to the end of all the named ranges...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top