VBA - filter column with multiple workbooks open

[tanyaleblanc]

I have three workbooks open, I've completed my tasks on the first workbook (Adjustment Report) and now I'm ready to complete my tasks on the second workbook (New Rental Contract). I want to activate the new rental contract report and put a filter on column O to filter for Takeover, the coding below is not working, not sure why I've used this same coding in other macros just tweaked it for this one.


lastrow = ActiveSheet.Range("A500").End(xlUp).Row
Windows("New Rental Contract.xls").Activate
.AutoFilterMode = False
With Range("a7:an7")
.AutoFilter
.AutoFilter field:=15, Criteria1:="Takeover"

 

[tanyaleblanc]

I figured this out and it works, please disregard

I have three workbooks open, I've completed my tasks on the first workbook (Adjustment Report) and now I'm ready to complete my tasks on the second workbook (New Rental Contract). I want to activate the new rental contract report and put a filter on column O to filter for Takeover, the coding below is not working, not sure why I've used this same coding in other macros just tweaked it for this one.


lastrow = ActiveSheet.Range("A500").End(xlUp).Row
Windows("New Rental Contract.xls").Activate
.AutoFilterMode = False
With Range("a7:an7")
.AutoFilter
.AutoFilter field:=15, Criteria1:="Takeover"