Hi,
I am trying to copy a region from one worksheet to another.
I receive the following error: 'Run-time error ‘438’:
Object doesn’t support this property or method'
This message relates to the last line of code below...
Worksheets("master").Select
Cells.Find(What:="Days Late", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
dlrow = ActiveCell.Row
dlcol = ActiveCell.Column
Range(Cells(10, 1), Cells(10, 52)).AutoFilter Field:=dlcol, Criteria1:="<-20"
Cells(dlrow, dlcol).CurrentRegion.Copy
Worksheets("DaysLate <-20").Range("A1").Paste
Bookmarks