View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xtian Xtian is offline
external usenet poster
 
Posts: 3
Default Keep cell reference when moving range (matter of urgency)

I have the following problem:

In the range C1:C20 i have some data. I the range A1:A20 i have this
"formula": In A10: =C10, in A11: =C11, and so on.

The problem is: I want to have the ability to cut for example the range
C17:C20 and paste it in the range C11:C14, WITHOUT changing the formulas in
the range A1:A20. That means, I do still want the formula in A11 to be =C11
(and not =#REF).

Thank you.