I am using this code to autosave to a specific server:


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveWorkbook.SaveAs Filename:="\\DTCNAS-ILSP002\Pricing\Builders Choice Completed\" & ActiveSheet.Range("a9")
End Sub

Can I modify this so that it saves only when a specific cell is filled?

Help!!! Thanks, Tawnee.