Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Aaaagh! Paste Function has ceased to work

Posted by Jos Williams on June 21, 2001 12:23 PM

I have been using the basic cleaning and length functions for months (i.e. =len(a2))and pasting this down the whole column....

suddenly i find that on pasting all the other cells repeat the copied value, in spite of the fact that the other cells refer to the correct cell.

Am i going mad?

Thanks

Check out our Excel Resources

On thought

Posted by IML on June 21, 2001 12:55 PM

Do they update when you hit F9? Is so, your sheet is probably manually calculating.

Ignore advice from people who can't spell "one"

Posted by IML on June 21, 2001 12:56 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.