If it's in a different workbook, I'd make sure I let excel do the heavy
lifting--either by pasting link or typing the = and pointing at the other cell.

Let excel worry about the brackets, apostrophes, exclamation points...

wrote:

And if it's in a different workbook add [WORKBOOK1.xls] in front of the
sheet2!a1. Excel will automatically add any directory referrences when
the WORKBOOK1 is closed and leave the directores off when the WORKBOOK1
is open. ed

--

Dave Peterson