LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Cut/Paste causes #REF

Hi Big Slick,
Looks like normal Cut/Paste behaviour, but I can't see the logic behind
it.
I do know that another difference between Cut and Copy of formulas is
that the pasted result after Cutting has the same original cell
addresses, while after copying the cell addresses change unless they
were absolute eg if the formula in A1 is =B1 + $B$2 then cut/paste
into A2 it doesn't change, while copy/paste into A2 and it changes to =
B2 + $B$2. This behaviour can be useful when you want to use a formula
in another part of the sheet without its cell addresses changing.
Ken Johnson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I repeat column headings on all of my sheets w/o cut/paste Momof3boys Excel Discussion (Misc queries) 1 September 16th 05 04:45 AM
Automate cut/paste functions - Help! Greg Excel Discussion (Misc queries) 2 June 13th 05 07:08 PM
Is there a way to retain a formula while performing cut/paste? Earl Excel Worksheet Functions 1 April 18th 05 10:08 PM
Can you drag/drop rows w/o using Cut/Paste spp Excel Discussion (Misc queries) 1 March 11th 05 03:05 PM
Excel cut/paste prob: Adds one day and changes year to 2009 Maisha1908 Excel Discussion (Misc queries) 3 February 7th 05 07:19 PM


All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"