Paste Formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Copy values only onto new workbook 1
Paste Values in linked Cells Only 4
Continue Excel to New Uear 9
Copy paste data from a column to a row 0
copy and paste 4
problems getting this macro to work 23
Paste Special 1
Special Pasting a work book with many sheets and formulas 2

Back
Top