Hi gurus,

Should be a simple one for you to crack, though isn't for me...

Lets say I have range A7:Z7 filled with "Y" or "N". I found the code that loops through this range and only selects columns with "Y". What I'm stuck on is I don't want to select entire row where "Y" was found, but only want rows 8 to 500 in that column selected? Question, what do I change EntireColumn.Select to?

Thank you guys!