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
:|>Unable to copy formula to other cells,
:|>=VLOOKUP(A2,Sheet2!$A$1:$B$4,Sheet2!$A$1:$A$4,FALS
:|>E). I have tried everything I can think of to copy this formula. Thank
:|>you
:|>
:|>
:|>---
:|>Message posted
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
