Absolute->relative link

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sid.varno@gmail.com - 06 Jun 2007 15:09 GMT

Hello all,

here's my problem:
I created a vba code that copy from a template 2 sheets and paste them
into a new workbook.
But in the sheet #2, there's some formulas like this: ='Valeurs NCAP'!
F3-$C3 where "Valeurs NCAP" is sheet #1.
Once the sheet copied in the new workbook, the link became:
='[Original_workbook.xls]Valeurs NCAP'!F3-$C3

How can I break this absolute link and transform it in relative link
to only keep ='Valeurs NCAP'!F3-$C3 ?

thanks in advance,
alex

Reply to this Message

Dave Peterson - 06 Jun 2007 15:46 GMT

One way is to save that receiving workbook and then do edit|links and change
source.

But I like to change all my formulas to text:
(with the recorder on???)
Select all the cells
edit|replace
what: =
with: $$$$$=
replace all

Then copy the cells and paste.

Then do the edit|replace in reverse:

Select all the cells
edit|replace
what: $$$$$=
with: =
replace all

(In both worksheets)

> Hello all,
>
[quoted text clipped - 11 lines]
> thanks in advance,
> alex

Signature

Dave Peterson

Reply to this Message

sid.varno@gmail.com - 06 Jun 2007 16:03 GMT

Thanks! Once I have read your answer, I have thought that it was not
what I need.
But in fact, it's!

Now, it works fine.
Thx
alex

Reply to this Message