I believe you just set the header cell values to what you want them to
be. No special property assignments are necessary for the cell.

So if your headers are in A1, B1, C1

Range("A1") = "myheader1"
Range("B1") = "myheader2"
Range("C1") = "myheader3'