Hi Cptn Jon,
The sheets in a workbook have names. By default
\Sheet1/ \Sheet2/ \Sheet3/
You can link to a cell in a specific sheet by
including the sheet name in the reference or by
using a named area in a sheet.
For example: to specify Row 1 column1 in a specific
sheet, such as Sheet 2 the link would be "Sheet2!R1C1
[Sheet/Tab name followed by an exclamation point then
the cell or range specification]
If you higlight the cells in Excel that you want in
your Word document then use Edit=>Copy, switch to
Word and use Edit=>Paste Special and click the
(o)Insert as Link
button you'll get the sheet link automatically
(use Alt+F9 in Word to see the linking code).
========
How do I set a hyperlink in MS WORD to each tab in a multi-TAB (30 or more
TABS) Excell workbook? I have not had any problems using only one tab
workbook.
Thanks>>
--
Let us know if this helped you,
Bob Buckland ?
MS Office System Products MVP
*Courtesy is not expensive and can pay big dividends*
Office 2003 Editions explained
http://www.microsoft.com/uk/office/editions.mspx