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


or...

instead of RefersToR1C1

use

RefersTo:=Range("A1:B2"

-----------------------------------------------
~~ 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