8-23-2012 10-38-35 AM.png
When the code below is run I'm not getting the green fill color on the newly added columns. The code worked fine until I added two columns to the spread sheet. The same two columns that won't take the fill color.
Thanks for the help,
Bernie
![]()
Range("FR").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _ Sheets("Criteria").Range("ResubmtCrit"), CopyToRange:=Range("A8000"), Unique:= _ False ' Filter 1
Bookmarks