Shorten vba code.

[satputenandkumar0]

Dear Members,

I have written below vba code to remove formulas in some ranges (because formula has other file links & I need to send report by email).
This vba code taking long time. Is there any way to shorten this code.

Please Login or Register  to view this content.

Thanks in advance.

[moinsk21]

Hi Satputenandkumar0,

Please attached the excel file so i will make the changes for you.

[MarvinP]

Not sure this will take much less time but code can be written as:

Please Login or Register  to view this content.

Or perhaps this is simpler and shorter?

Please Login or Register  to view this content.

[MarvinP]

Try this one fro FASTER!!

Please Login or Register  to view this content.

[satputenandkumar0]

Dear MarvinP & moinsk21

Thanks for reply,

Marvin, Your second option works nice in much less time.

Thanks