Thanks Ajit, but I've tried this. The define name dialog box accepts
it with the filepath, but once I close the other workbook and try to
update the range I get the error. Ive created two simple workbooks
that demonstrate the problem, if I can figure out how to post them
here.
Angelo
On Jul 21,
Yes, once I close the source workbook, the filepath isn't added
automatically and I get a REF error.
On Jul 21, 8:48 am, Luke Mercer wrote:
> Do you mean that the 'links' funciotnality is not updating the directory and
> path of the model when the link is via a rangename?
> Thats a good idea, to
I'd love to, but for whatever reason I can't see your email address
and can't attached a sample workbook in this post
On Jul 21, 8:33 am, "Daniel" wrote:
> Can you mail back a sample file ?
>
> Regards.
>
> Daniel
--~--~-~--~~~---~--~~
---
glegroups.com
Subject: $$Excel-Macros$$ Re: referenced named range on a closed workbook
Do you mean that the 'links' funciotnality is not updating the directory and
path of the model when the link is via a rangename?
Thats a good idea, to correct for row insertion / column insertion - it
Do you mean that the 'links' funciotnality is not updating the directory and
path of the model when the link is via a rangename?
Thats a good idea, to correct for row insertion / column insertion - it had
never occured to me before.
Luke
--
Mercer PPP / Project Finance:
Excel Financial Model Se
Can you mail back a sample file ?
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of AngeloUCF
> Sent: lundi 20 juillet 2009 21:08
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ referenced named ra
