When I link to another sheet and cell, instead of showing the cell reference
in the formula bar, and as much of the content of the cell as the width of
the cell, is there any way to display all the content of the cell I'm linking
to by using a formula? I am using a hyperlink (from the formula button, not
insert hyperlink which doesn't seem to work in the same way) - is there a
better way?

If I understand you correctly you need a formula of the type: =Sheet3!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lynn" wrote in message
...
When I link to another sheet and cell, instead of showing the cell
reference
in the formula bar, and as much of the content of the cell as the width of
the cell, is there any way to display all the content of the cell I'm
linking
to by using a formula? I am using a hyperlink (from the formula button,
not
insert hyperlink which doesn't seem to work in the same way) - is there a
better way?

Hi there, many thanks, but not what I meant! Once I've got the formula, I
would like to be able to show the full content of the cell I'm linking to (it
is text) rather than the truncated view (as there is info in the adjoining
cell) without widening the column or using a hyperlink formula.
Thanks Lynn

"Bernard Liengme" wrote:

If I understand you correctly you need a formula of the type: =Sheet3!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lynn" wrote in message
...
When I link to another sheet and cell, instead of showing the cell
reference
in the formula bar, and as much of the content of the cell as the width of
the cell, is there any way to display all the content of the cell I'm
linking
to by using a formula? I am using a hyperlink (from the formula button,
not
insert hyperlink which doesn't seem to work in the same way) - is there a
better way?

Maybe some variation of this will help....

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' This macro, placed in a WorkSheet module will automatically
' copy a cell's value over to it's comment box, so large text
' fields in a cell can be viewed without resizing the worksheet.
On Error Resume Next
ActiveCell.Comment.Text Text:=ActiveCell.Value
End Sub

Vaya con Dios,
Chuck, CABGx3


"Lynn" wrote:

Hi there, many thanks, but not what I meant! Once I've got the formula, I
would like to be able to show the full content of the cell I'm linking to (it
is text) rather than the truncated view (as there is info in the adjoining
cell) without widening the column or using a hyperlink formula.
Thanks Lynn

"Bernard Liengme" wrote:

If I understand you correctly you need a formula of the type: =Sheet3!A1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lynn" wrote in message
...
When I link to another sheet and cell, instead of showing the cell
reference
in the formula bar, and as much of the content of the cell as the width of
the cell, is there any way to display all the content of the cell I'm
linking
to by using a formula? I am using a hyperlink (from the formula button,
not
insert hyperlink which doesn't seem to work in the same way) - is there a
better way?