Auto Insert Blank Row For Each Cell That Ends in....

Hi,
This is a helpful code that auto inserts a blank row above the Total line to maintain the proper formula range. How do you replace Range("Total") to be, For each cell in column D that ends in "Monthly % Change", it would still insert a blank row above the Total line?

Please Login or Register  to view this content.

Thanks,
Ricky