Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Rename a Range, programatically?

Gurus:
Say I have a named cell range:
Range("MyName")
and I want to change the name:
Range("MyNewName")
Is there a way to do this using VB?
I have tried various ways, and excel (97) rejects them all.
Any Help Greatly Appreciated,
-plh

I keep hitting "Esc", but I'm still here!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
how do i rename a sheet if the rename tab is inactive? Nelson Excel Worksheet Functions 1 March 3rd 10 10:28 AM
Rename a range . LAB Excel Discussion (Misc queries) 2 April 2nd 09 11:08 PM
Copy, Paste and Rename a Range using a macro [email protected] Excel Discussion (Misc queries) 1 April 15th 08 03:58 PM
How to rename references from range names to cell references Abbas Excel Discussion (Misc queries) 1 May 24th 06 06:18 PM
How do I rename the A B C cell range along the top of excel Treasuris Excel Worksheet Functions 1 September 26th 05 08:42 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"