Module fails when in break mode

[stubarny]

Hello All,

Please could someone explain why the following module breaks when in break mode (when each line run in turn using the F8 button) but when I run the macro out of break mode it is fine (in break mode it is failing on the last line shown below):

Sub Outputreport()
Application.DisplayAlerts = False
 
                 Rowno = 6
                 Do Until Cells(Rowno, 1) = ""
                  'Cells(Rowno, 1).Select
                  WkName = Cells(Rowno, 1).Value
 
                  SaveName = WkName & Cells(2, 3).Value
 
 
 Windows("ReportCreationMacro.xls").Activate
  Sheets("FunctionReports").Select
 
 
 
Selection.AutoFilter Field:=4, Criteria1:=WkName

Thanks,

Stu

 

[RoryA]

Failing in what way?

 

[stubarny]

Hi Rory, this is the error message:

Run-time error '438'
Object doesn't support this property or method

but the error message doesn't appear when out of break mode

Stu

 

[RoryA]

I would suggest your code would be better specifying a range to filter, rather than assuming that the correct range is selected.