The Excel #Ref! error means there is an unknown reference or address in a cell formula. There are times where you want to copy and paste cells (ctrl+c) vs. cutting and paste(ctrl+x). One problem with cutting is that you can create #REF! to an existing formula. To see this, enter into: A1 the number 1 A2 =A1+1 Cut A3 and paste to A1 A2 = #REF! Instead Copy A3 and paste to A1. |