Thread: assign a name to a cell using vb
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default assign a name to a cell using vb
Sub Macro1()
ActiveWorkbook.Names.Add Name:="qwerty", RefersToR1C1:="=Sheet1!R3C2"
End Sub
--
Gary''s Student - gsnu200806


"jnewl" wrote:

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