Hi

It is strange, based on my test, even I put breakpoint and the
SetOptionsToParetoAlternative will run, but it seems that the cells is not
changed.
So I just wonder maybe the logic may not correct.
So far I think you may try to create a new workbook and add the code one
by one to see what code line may cause the problem.
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.