Hi,

Why isn't there an icon for pasting formulae only, there is for values and
formats? I've written a macro to do it but this is not ideal because you
need the workbook with the code open.
--
Andrew

Hi Andrew,
You could make a macro and assign a toolbar button of your own design.

Another possibility is to use a context menu (right click menu)
with additional items named "Copy Formula". and "Paste Formula"
Chip Pearson posted the method but there were some tune-ups to it
in that thread.
..
You can pick that up and a few other similar things related to invoking
some of my macros through the context menu..
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Andrew" wrote in message ...
Hi,

Why isn't there an icon for pasting formulae only, there is for values and
formats? I've written a macro to do it but this is not ideal because you
need the workbook with the code open.
--
Andrew