About formating the Cells when exporting to Excel

Mengku

hey, I'm new here. I have a problem with the formating the cells when export a report from Navision to Excel.

How to merge the cells and centralize the text in that cell? And also how to draw the border lines?

Anyone could help me? Many thanks!

kine

As always, try to record macro with actions you want to do, after that, look into the VB code and try to write same or similar code in C/Al... ;-)

garak

right, as i ever say: Start a macrocecording, do that what navision in your excel application should do, stop the recording an visit the vb code. This code is very simple to "transfer" to C/AL.

Regards

Mengku

Thank you so much guys, that's very helpful, I already found the solution!