Maybe something like:

Workbooks("book2.xls").Worksheets("sheet1").Range( "c4").Formula _
= Workbooks("book1.xls").Worksheets("sheet1").Range( "e6").Formula





Thomas Wright wrote:

when working out the details I often "perfect a formula in one workbook and
then paste it into another. However, I can not find a wyanot to paste the
formula with ref. to the first notebook. I then have to spend more time
deleting references. Its a bit of a hassle.

Is there a way not to paste the ref. to the first workbook?

Thanks

Tom

--

Dave Peterson