Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Name Range using VBA
Hi,
I need to create sheet level Dynamic range names in a workbook using VBA.. This is what I insert in the RefersTo box while creating a name manually: =OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B$3:$B$500) ,1) How do I do it in VBA? Thanks in Advance for the help. Regards, Raj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Name Range using VBA
Try recording a macro while doing
Sub Macro3() ' ' Macro3 Macro ' Macro recorded 4/20/2010 by Donald B. Guillett ' ' ActiveWorkbook.Names.Add Name:="xxx", RefersToR1C1:= _ "=OFFSET(Sheet1!R1C1,1,1)" End Sub ============ or Sub makename() ActiveWorkbook.Names.Add Name:="yyy", RefersTo:= _ "=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B$3:$B$500 ),1)" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Raj" wrote in message ... Hi, I need to create sheet level Dynamic range names in a workbook using VBA.. This is what I insert in the RefersTo box while creating a name manually: =OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B$3:$B$500) ,1) How do I do it in VBA? Thanks in Advance for the help. Regards, Raj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
select dynamic range with dynamic start point | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |