Macro format selection
 

Hi here is part of my macro,

Selection.AutoFilter Field:=3, Criteria1:="FC"
Rows("2:51").Select
Range("A51").Activate
Selection.Font.ColorIndex = 5


My data is different every day. so
Rows("2:51").Select -------------- this could be from 2:40 or 2:75
Range("A51").Activate


How do I write it so that it will select only Criteria1:="FC"

Thank you.