Reply to thread

Message: [QUOTE="Yuvraj, post: 6374833"] Hi Friends, I want to know is there some steps we need to know whether the code within should not have comparisons or any other thing Application.xlcalculation=xlmanual <code> Applicatioon.xlCalculation=automatic My understanding is that if the cell used in the sheet should not be referenced by any other sheet. If those cells which are referenced by some other sheets for calculations setting the calculation off while performing a save in the active sheet which needs calculation to be set to manual for speed will hamper the functionality before i turn it to automatic again. I have put question mark where I have doubt. Please give your views so that i can understand when i can turn it off as it is hampering the performance. If [dt2.corep] > 0 Then //Will this be an issue??? like here i am comparing one cell if it is greater than zero so should calculation if set to manual will be problem Also ((WorksheetFunction.count(kaWks.Range will these functions be a problem If rInput.offset(8, 1) Like "[SR]" Or rInput.offset(8, 0) = "Y" // ****Will this be a problem as we are comparing ???????? ElseIf rInput.offset(8, 1) = "F" And rInput.offset(8, 0) = "N" //Wil tis be a problem ??? Also we have sometimes Worksheet.Sum If IsEmpty(rInput.offset(12, 9)) = True And WorksheetFunction.Sum Regards, Prince [/QUOTE]