Macro taking a lot of time

[anumolud]

Guys,

I have the following code that is taking a lot of time. I am a novice in vba and built this code with the help of Google. Please help me to optimize this.
Thanks.

Please Login or Register  to view this content.

[TMS]

It would help if you posted a sample workbook with some typical data,

Regards

[nimrod]

hint : don't use "Select or Selection" in your code , just to reference cells ... this is very costly and leads to mistakes. "Select" means you actually going and ummm touching each cell .

Please Login or Register  to view this content.

[anumolud]

nimrod:

that worked like a charm. it takes only a sec now. thank you so much.
though i don't completely understand it, it just works great .