Posted to microsoft.public.excel.programming

rickv

external usenet poster

Posts: 1

Defined Names

There are thousands of Defined name to be renamed. The prefix of thes
defined names is bb and would like to change the prefix to xxxbb. Thes
defined names are used in formulae. How do I create the macro or vba t
do the job.
Thanks for your help

--
rick
-----------------------------------------------------------------------
rickv's Profile: http://www.excelforum.com/member.php...fo&userid=2594
View this thread: http://www.excelforum.com/showthread.php?threadid=39350

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why use defined names?	Eric	Excel Discussion (Misc queries)	2	December 31st 07 06:07 AM
Defined names	lesley1000 via OfficeKB.com	Excel Worksheet Functions	3	December 10th 07 02:50 PM
NAMES DEFINED	F. Lawrence Kulchar	Excel Discussion (Misc queries)	5	November 14th 06 07:54 AM
Defined names	DREED	Excel Discussion (Misc queries)	3	March 10th 06 02:55 PM
Using defined names in VBA...	BeSmart	Excel Programming	4	September 24th 04 10:11 AM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us