Dinesh_Excel
Member
Hi All,
Can you please help me in finding a code where I have a list of 40 odd Excel files which have conditional formatting and Data validation in every File.
Is it possible to remove all the formatting and data validations for all 40 excel files using vba code.
Attached sample for your reference.
Can you please help me in finding a code where I have a list of 40 odd Excel files which have conditional formatting and Data validation in every File.
Is it possible to remove all the formatting and data validations for all 40 excel files using vba code.
Attached sample for your reference.