ref error

Originally Posted by censura

the ref error is being produced when i change the formula in column o from changing the e6 to e7 and the k7 to k8 and similarly changing d6 to d7 and j7 to j8 even when i use the correct formula you propossed.
hope you can help

I am still unable to reporoduce your stated error, the file you posted does not show any errors.
The change you suggest would occur normally on a formula fill

the formula

=IF(AND(E6<K7),-1,IF(AND(D6>J7),1,0))

could be reduced to

=IF(E6<K7,-1,IF(D6>J7,1,0))

however, either should work.

As told before, I need to cancel your macro which errors at the line

Set objFiles = objFSO.GetFolder(myPath).Files

so if something in the macro causes the error I would not be aware of it.