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.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
