Excel VBA application performance.

[divakarganta]

HI,

I am new to Excel VBA programming and assigned to Excel VBA support project to work on to increase the performance of excel with VBA programming.
I am facing problem with excel with VBA Programming where saving data to excel its taking long time to save. and after enter data in one excel and going to another cell here also its taking long time.

Here is the code:

Please Login or Register  to view this content.

while debugging in the last line code taking long time to process through.
Pls give me aolstion for the above and tips to increase the performance.

[JosephP]

who assigned you to support a vba project if you don't know anything about vba? ;-)

you probably just need to turn calculation to manual while your code is changing values (unless the code depends on the calculations)

Please Login or Register  to view this content.

[zbor]

divakarganta, please use code tags around code.
I've edit it this time for you.