Have you used debugging to see if the code is running but the If is failing?

VBA: How to Debug Code - Overview, Tools, Shortcut Keys (corporatefinanceinstitute.com)