function not defined

  1. M

    Compile error: sub or function not defined

    hi there, once again i've got a problem. i want to export a single sheet of my workbook into a new workbook. therefore i've got the following code: sheets("Channel").Copy ActiveWorkbook.SaveAs fileName:="C:\test.xls" ActiveWorkbook.Close but if i run that sub, i get this error: Compile...

Some videos you may like

This Week's Hot Topics