Hey Guys
I want to use the codename for the macro because the sheet name will need to be regularly changed, but it comes up with "Run time error '424'...object required" Can someone please help?
I want to use the codename for the macro because the sheet name will need to be regularly changed, but it comes up with "Run time error '424'...object required" Can someone please help?
Code:
Sub transfer_data()'
' transfer_data Macro
'
'
Windows("CH Normalisation.xlsx").Activate
Sheet49.Select
ActiveWindow.SmallScroll Down:=-9
ActiveSheet.Range("$A$1:$AK$39693").AutoFilter Field:=1, Criteria1:= _
"Flight Centre Limited"