Hey guys & girls. I have looked all over and can't seem to find what I am looking for. Need VBA help. I have a sheet with multiple columns. I need to set a dynamic range A:J when cells in row of D:F all = 100%. (All the row data I want to capture above that point have at least 1 column that is less than 100% in D:F). The range changes from day to day so it needs to be dynamic (or at least I think it does ). Thanks for any suggestions.