- Sep 14, 2005
- Office Version
I am trying to filter a list of records by the value in a cell and then (for the filtered result(s)) change the value in column Y just for the filtered results. This is the code I have at present which filters the records OK but I can't fathom what I need to do to ensure I only chnage the value of the cell(s) in column Y?
ActiveSheet.Range("$A$1:$DC$5000").AutoFilter Field:=1, Criteria1:="GI255" [COLOR=red]'After filtering I want to change the value in column Y for only the filtered entries[/COLOR]CODE]