I have an excel report which was generated from Navision and I want to add autofilter function in columns heading. User can filter data in columns heading. Thanks for kindly help;
Hi Satit, Sheet.Range(‘C:D’).AutoFilter; VarName,DataType,Subtype Sheet,Automation,‘Microsoft Excel 9.0 Object Library’.Worksheet