VBA Code, how to define range of found column header properly

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,649
Office Version
365
Platform
Windows
You filling the entire columns with a white background & then looping through the columns & checking if the background is NOT white.
As it will always be white, the inner loops never trigger.
Try stepping through the code with F8 & you will see that happening.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,102,334
Messages
5,486,220
Members
407,537
Latest member
Frank Nunez

This Week's Hot Topics

Top