At 15:02 04/12/2007 +0000, Brian Barker wrote:
At 06:33 04/12/2007 -0800, Walter Hildebrandt wrote:
Under Options "Link" is selected. Under Selection "Paste all" is
selected. I am copying a column that has formulas in it. The
answer to the formula is Pasted, not the formula itself. At the
top of the heading is a name. The name which is text can not be
found with the "Find & Replace" function.
If you paste a link, you don't have the results of any formulae, in
fact, but simply new formulae that refer back to the cells that are
the source of your copy and paste. And it's not surprising that you
cannot find the text with the Find function, since the text that you
see doesn't actually appear in that cell - only a formula whose
result is that text.
If you really want a link there instead of a copy of the content of
the original cells, it doesn't make sense to want to replace
anything anyway. Conversely, if you want to modify the copy,
perhaps you don't want a link in the first place. Untick the Link
option in the Paste Special: does that help? Or perhaps what you
may really need is a link to the column of formulae but separately a
copy - not a link - of the cell containing the heading. Then you
can sensibly search for and modify that heading.
Actually, I wasn't being as helpful as I might have been here. You
can find text in the cells containing links, in fact: you just need
to choose the appropriate option. By default, Find searches in
formulae rather than in their results. To search the results of
formulae (as your text here is), choose More Options in the Find &
Replace dialogue, and then choose Values in the "Search in" drop-down
menu. This is the answer to your original question, of course.
I trust this helps more than my previous effort.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
