On Aug 8, 1:18 pm, geebee (noSPAMs) 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

Guess number one: I think you might need parens around your lookup
functions??

= lookup(parameters,range) I never us R1C1 notation so you may be able
to omit parens using that syntax.

eholz1