I try to write header information for a worksheet but it gives me syntax error. This is the part of the code that I use that give error
wsCon is worksheet defined early
With wsCon.Cells(1, 1).Resize(, 33)
Value = [{"No","Company ID","Company Name","Contact Person","Address","City","Pin Code","Phone","Alt Phone","Fax","Order","Quantity","Order Date","Dispatched","Courier Name","Tracking ","Delivery ","Pre-","","Excise ","","Stock ","Checked ","Checked ","","Vendor ","Vendor ","Vendor ","Origin ","Vendor ","TP ","Comments","Notes"}]
.Interior.ColorIndex = 11
.Font.Color = vbWhite
.Font.Bold = True
End With
Me think the Value line is too long and I get syntax error as it more than 255 characters i think. Can someone help with this last issue . What doing wrong here?
Thanks veryy muchhhh !!!!
Bookmarks