Hello,
I am trying to make it do if the file name is something do a code. if it is not , if it is anything else than what i stated do something else.
How can i call name of the files under IF ?
I am trying to make it do if the file name is something do a code. if it is not , if it is anything else than what i stated do something else.
How can i call name of the files under IF ?
Code:
If Workbooks("5519_capacity_report_short.xls") Then
Rows("2:2").Select
Selection.AutoFilter
Else
Rows("3:3").Select
Selection.AutoFilter
End If
