To make this code to work, i changed the file name to Dump Aging Report and now its working fine...
Also how to set up a Message box, if the result is False in the below code. Here i am looking for a Reference : IC1012.
ActiveSheet.Range("$A$1:$Y$1299").AutoFilter Field:=17, Criteria1:="IC1012"




Reply With Quote