Thread: Creating a Named Range using VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
WillR[_2_] WillR[_2_] is offline
external usenet poster
  
Posts: 1
Default Creating a Named Range using VB

try this code


Code
-------------------
Sub NameARange()
Range("AD2:AD" & Range("AD2").End(xlDown).Row).Name = "MyName"
End Su
-------------------


Hope this helps,

Wil

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Reply With QuoteReply With Quote