How to merge excel cell when we are printing nav classic report in Navision.

Please tel me how to merge cell in excel.

Suppose i want “SALES INVOICE REPORT” written in multiple columns in excel. How to do it in navision?

Welcome to DUG

Please search forum/google before posting

Did you try

XlSheet.Range(‘A1:A2’).Cells.Merge;

Are you using excel buffer or Excel Automation ??

Actually I am using excel buffer?

Check this blog

http://saurav-nav.blogspot.in/2012/05/navision-export-to-excel-with-merge.html

its exactly wat i needed.