Thread: assign a name to a cell using vb
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default assign a name to a cell using vb
ActiveWorkbook.Names.Add Name:="nametoassign", RefersTo:="=Sheet1!A1"
assigns name "nametoassign" to cell A1 in Sheet1.

Regards,
Stefi

jnewl ezt *rta:

what is the code to assign a name to a cell using vb?
thanks
Reply With QuoteReply With Quote