VBA Simplification

Hello all,

i have a macro code pasted below[it's working fine], this report contains full of excel formula's and connected the same file with the other sheets. And each and every sheet contains more than 1000 rows and 50 column full of formatted and formula's. it contains more than 40 sheets when i run this code it's taking too much time to produce the each "Call" wise report. so my request is this any other way to simplify this code would be fine. first it will start with Find_data().

Please Login or Register  to view this content.

Thanks\Raj

I don't see anything in your code that would slow it down, other than the fact that you are loop 40 sheets. but this by you:

it's taking too much time to produce the each "Call" wise report

I did not follow because there is nothing in your code that says anything about a ""call wise"" report.

fine Norie, let me check Thank you....