Hi Franz,

I often had the same problem.
You might find the following macro useful:

Sub CopyFormulaToClipBoard()
With New DataObject
.SetText ActiveCell.Formula
.PutInClipboard
End With
End Sub

HTH
--
AP

"Franz Verga" a écrit dans le message de news:
...
Nel post
*Norman Jones* ha scritto:

Hi Frank,

=VLOOKUP(A1;Sheet1!$A$1:$B$100;2;FALSE)

I think that you intended:

=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE)

(semicolons replaced with commas)



Hi Norman,

You got it.

I wrote the formula directly in OE, so I wrote in the Italian way... ;-)

--
Ciao

Franz Verga from Italy