Place an apostrophe at the beginning of the cell... making the formula a
string...

<f2
<HOME
<'
<enter

Now you can copy it to a new workbook or a new field within the worksheet.- I
use this to store all my formulas and/macros in a single workbook.

You will have to rename the cells and ranges... but I find this the easiest way
copy formulas.

On Mon, 13 Sep 2004 22:19:50 -0500, BRustigian
wrote:

:|Unable to copy formula to other cells,
:|=VLOOKUP(A2,Sheet2!$A$1:$B$4,Sheet2!$A$1:$A$4,F ALS
:|E). I have tried everything I can think of to copy this formula. Thank
:|you
:|
:|
:|---
:|Message posted from http://www.ExcelForum.com/

Bravejoe

"That's my opinion. I could be wrong." Dennis Miller
"It Doesn't Matter!" Bravejoe

remove the "t1","us" and replace "com" with "net" from my email address to reply privately.

"There's fodder for the cannons and the guilty ones can all sleep safely." Andy Partridge XTC