View Single Post
  #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