Thread: Using VB to to create named ranges
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default Using VB to to create named ranges
OP wanted to leave out sections.

--
HTH

Bob Phillips

"keepITcool" wrote in message
ft.com...
activesheet.usedrange.name = "MyName"




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Phillips wrote :

How about something like

Set rng = Range("A1:A10, B5:B8,H5:H18, M5:O10")
rng.Name = "RangeName"


Reply With QuoteReply With Quote