Make the below code work faster!!!
Hi,
I want to make this code work more faster.Actually this code is for adding rows below a already existing table.The table has conditional formatting and Data validation.
for that only I have used the copy and paste.
I have already used Application.ScreenUpdating = False
in the begining of the code.
In the below code "x" is for number of rows to be inserted.If 2 has to be inserted means then the code runs 2 times and so 2 rows are inserted.
Please Login or Register to view this content.
Hello devpp,
With your Application.ScreenUpdating= False, try adding Application.Calculation= xlCalculationManual,and then at the end of your Code, with Application.ScreenUpdating = True, add also Application.Calculation = xlCalculationAutomatic.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Actually I cant add xl calculation as manual as there is some calculations involved when the rows are added in another sheet.so is there any other alternative?Originally Posted by Winon
Hello devpp,
With your Application.ScreenUpdating= False, try adding Application.Calculation= xlCalculationManual,and then at the end of your Code, with Application.ScreenUpdating = True, add also Application.Calculation = xlCalculationAutomatic.
Hello devpp,
Since Calculation is turned back onto Automatic at the end of the Code, it will not effect any calculating requirements in any sheets.Actually I cant add xl calculation as manual as there is some calculations involved when the rows are added in another sheet.
Just do it, and see for yourself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks