Posted to microsoft.public.excel.programming

external usenet poster

Posts: 190

change named range

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Named range in chart - any way to change the workbook reference with VBA	Graham Whitehead	Excel Programming	1	October 23rd 07 03:02 PM
Named Range Change Based On AutoFilter	SanctifiedRock	Excel Programming	3	May 16th 06 03:27 PM
Change event triggered by a named range	Sean	Excel Programming	4	August 1st 05 03:01 AM
Change Event on a named range	GregR	Excel Programming	2	July 12th 05 09:37 PM
Change named range value	Joe Boucher	Excel Programming	2	September 30th 04 01:41 AM

All times are GMT +1. The time now is 02:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us