So guys, I am trying to tell VBA to Paste Format over every column if the condition is met within the Range (C1:N1) equalizing to 1.
I've this script working for Grouping Columns in other reports but I cant figure out how to tell it to do PasteFormat instead.
Columns("Z").Select...