ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cells name or range name in a worksheet (https://www.excelbanter.com/excel-programming/352037-cells-name-range-name-worksheet.html)

Jean-Pierre Bidon

cells name or range name in a worksheet
 
Hie,
It seems so simple, but...
I allocated a name to a range of cells in a worksheet. After a while, I'd
like to alter the name because it doesn't suit me anymore.
The problem is that I dont know how to delete or alter the old name. Is it
possible, either through the Excel interface or with a Macro?
Thanks in advance.
Jean-Pierre

--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17



Bob Phillips[_6_]

cells name or range name in a worksheet
 
Get hold of Jan Karel Pieterse's NameManager, it will do you what you want

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jean-Pierre Bidon" wrote in message
...
Hie,
It seems so simple, but...
I allocated a name to a range of cells in a worksheet. After a while, I'd
like to alter the name because it doesn't suit me anymore.
The problem is that I dont know how to delete or alter the old name. Is it
possible, either through the Excel interface or with a Macro?
Thanks in advance.
Jean-Pierre

--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17






All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com