Delete Particular range data in 3 worksheet on closed workbook vba...

Dear sir

I have code to run on closed workbook from active workbook (code) to delete particular range of data consistently in 3 sheets on different column

for e.g

In Aegis workbook consists 3 sheets 1.CDS-RD = Delete all data apart from Aegis in col "FP:FP" 2.TAT_NPRA_RMA_ENGG-CERT = Delete all data apart from Aegis in col "G:G" 3.PPRN-RRR = Delete all data apart from Aegis in col "G:G" I

code which i have run for first sheet only my requirement how make it same consistency to another 2 sheets..

Please Login or Register  to view this content.

Find the attachment

Sir Superb solution... works perfectly!!!!! Solved