Hi,

Select both column A and L and then do the cut operation.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ben" wrote in message
...
I have a list of numbers in column A6:A39 I rotate these numbers from A39
to
A6 by cut and insert cut cell method. In column L I have a formula
IF(A6=1590,4502,"") thru to IF (A39=1590,4502,"").When I
rotate column A,the formulas in col L change to IF(A7=1590,4502,"") .The
A6,etc increase by 1. How can I prevent this from happening.
reguards,Ben
--
Reynella