Change multiple cell names at once?

[bluehawk]

I have named multiple cells different names, but they all include the same format. for example:

hello_2_hi
hello_4_meet
hello_2_me

is it possible to replace "hello" to something different all at the same time?

NOTE: I'm talking about the cell name, not cell content.

 

[shg]

Welcome to the board.

No, it's not.

 

[sheetspread]

This is for named ranges:

http://www.mrexcel.com/forum/excel-...e-ranges-using-visual-basic-applications.html

which I thought you had, but maybe not

 

[bluehawk]

awww thanks anyway, guess I will have to do 40 name changes manually XD

 

[marcelocbd]

Does the named cells have a specified range like from A1 to Z30?

 

[shg]

You can do it via VBA quickly enough that it looks all at once -- but not from the UI.