Clear Content of Select Cells in Newly Inserted Rows and Keep Data Validation

*Hi All.

I have a VBA code that selects multiple worksheets to insert new rows. It then drags functions down to the new rows from a previous row above to keep data validation format.

Every time this macro is ran, the number of rows and the range of insertion will differ. How would I go back to cells D through F, J, O and R of newly added rows to clear the contents?
Sample_Workbook.xlsm
I have attached a sample workbook for viewing.

Thanks you in advance.

Try something like this...

Please Login or Register  to view this content.

Thanks AlfaFrog. The code is not selecting all the sheets All_Fund_Series, MAPMG, and SCPMG to be modified at onces as needed. It's only applying it to the All_Fund_Series sheet. Is there a reason why?

You cannot do a .Find on all the sheets at one time.

Use the For-Next to loop through the sheets instead of the Set ws..

Uncomment the already included For-Next

Comment the Set ws = Sheets("All_Fund_Series")

That's it.

Yes! Worked like a charm. Thank you.