View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
plh[_2_] plh[_2_] is offline
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!