Just to clear up some doubts, I brought the files to work to test.
It was giving the same errors, so I put =-1 in the VBA code again, and it works correctly.
Public Sub DeleteTempCF(r As Range) Dim c As Range Dim LoopCounter As Long '// Simply loops all CFs in a range, deleting those where the formula is '=True' For Each c In r With c For LoopCounter = .FormatConditions.Count To 1 Step -1 If .FormatConditions(LoopCounter).Formula1 = "=-1" Then .FormatConditions(LoopCounter).Delete End If Next End With Next End Sub
Here I also have Excel 2007, so I don't know why my excel at home doesn't work.
I already uninstalled it, and reinstalled it and it stayed the same, if you can tell me why it is, and what should be done, I would be grateful.
If I have to uninstall excel again and delete something in regedit, so that nothing remains in the pc's memory.
So, it seems that the problem was solved, now I just need to see what is happening with my excel at home.
I want to thank all the help given by both gijsmo and cytop.
They were spectacular, unsurpassed, tireless, despite the fact that I had already given up, they stood firm in helping me with this problem.
I'm glad there are people like you on this Forum to help those in need, because without you we would be lost.
I want to publicly thank you for all the help you have given me in solving this problem, because without you I would not have been able to.
My most sincere thanks.
Good week to you.