Thread: assign a name to a cell using vb
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default assign a name to a cell using vb
Dim myCell as range
set mycell = activesheet.range("x9")
mycell.name = "avalidnamehere"



jnewl wrote:

what is the code to assign a name to a cell using vb?
thanks

--

Dave Peterson
Reply With QuoteReply With Quote