Hello,

Using the code below I was able to sucessfully merge the given cells but I am now unable without any such luck to Center the Range A1:P1

Any ideas as to what the code would be to center text in the specified row given the code below?

Thanks for everyones help in advance,

Cheers,

Jay

var excel	= new ActiveXObject("Excel.Application") 
var book	= excel.Workbooks.Add() 
var sheet	= book.Sheets(1);

excel.Visible = true

sheet.Range(sheet.Cells(1, 1), sheet.Cells(1, 16)).Merge();