Cannat paste that macro formula onto a worksheet

  • Thread starter Thread starter Stephen White
  • Start date Start date
S

Stephen White

When I try to copy cells from one worksheet to another in the same
workbook (using both Excel 97 and Excell 2000) I get the message

Cannot copy that macro formula onto a worksheet

I get this even when the cell being copied does not contain a formula
although the worksheet/workbook does contain macros.

As far as I am aware neither the workbook nor worksheets are protected.

I can't find any help either in Excel Help or in the Microsoft Knowledge
Base.
 
Yes, that seems to do the trick.

But why doesn't clicking the Paste button do it equally well?
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
problems getting this macro to work 23
Paste Values in linked Cells Only 4
Excel Count If Formula Question 1
corrupted formula in protected worksheet 21
Multiple worksheet Copy Paste Macro 2
Copy same formula to all worksheets in a workbook 1
VBA Copy values only onto new workbook 1

Back
Top