Thread: [Solved] Cut & Paste issue
View Single Post
 
Old 06-13-2012, 03:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In general:
• When you cut & paste a range, any formulae will continue to point to the original locations.
• When you cut & paste a range, any relative address formulae will point to a new original locations.

However, if you:
• cut & paste a range to a destination that was referenced by any formulae, any formulae referencing the destination will be invalidated. This applies regardless of whether the formulae were part of what was cut or were simply referening the destination range from some other part of the workbook.
• copy & paste a range using relative address formulae to a destination that results in those formulae pointing to a on-existent range (eg A-10), those formulae will be invalidated.

If the formulae in the range you're cutting & pasting are being invalidated, that suggests you're pasting to a range that those formulae were referencing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote