My "paste special - formula" in Excel pasts values and formula?

G

Guest

I want to copy and paste formulas ONLY. When I use "paste special -
formulas" to copy and paste a row of cells containing both values and
formula, the cells containing values are copied and pasted as well as the
cells containing formula. How can I prevent the values being pasted?

(I have checked that the cells are formated "General" not "Text"). (The
formats are also pasted)

Thanks to anyone who can help.
 

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

Office 2007 Excel Paste Special formula only 1
Paste Special Values 2
Paste special from cells without formulas/formats 2
VSTO Paste 0
Macro to copy & paste-special-values data to selected worksheets 1
Paste Special prob 2
Remove date format? 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6

Top