hi,

i want to be able to know how to change the named range while also adding
the header row in row 1. for example, if the new range is like rows 56 - 99,
this new range does not include the header row, so i cant use it as a graph
source. what do i need to do?

thanks in advance,
geebee


"Dave Peterson" wrote:

I don't see that last comma, zero and close paren: ,0)
in your code.

ActiveWorkbook.Names.Add Name:="MONTH_SOURCE2", RefersToR1C1:= _
"='lookup'!R1C28:OFFSET('lookup'!R1C28, 'lookup'!R" & NEWMO3 & "C29,0)"

geebee wrote:

hi,

i am trying to yield/get at this new range programmatically:
=lookup!$AB$14:OFFSET(lookup!$AB$14,lookup!$AC$100 ,0)

by using:
ActiveWorkbook.Names.Add Name:="MONTH_SOURCE2", RefersToR1C1:= _
"='lookup'!R1C28:OFFSET('lookup'!R1C28, 'lookup'!R" & NEWMO3 & "C29"

but i cant figure out what is wrong with my syntax.

thanks in advance,
geebee

--

Dave Peterson