Thanks Killian,


Rather than executing all these properties for each table cell
.TextRange.Font.Size = 14
.TextRange.Font.Name = "Arial"
.TextRange.Font.Color.RGB = 16777215
.TextRange.Font.Bold = msoTrue
.HorizontalAnchor = msoAnchorCenter
.VerticalAnchor = 3
whether we can format first cell(1,1) and copy this cell to next cell(1,2) and set the text for this(assuming that it will grab all the properties set for this cell when we copy first cell). I think this will improve the performance (I'm guessing).


If this improves performance then please let me know, how to copy and paste cell values.



Please advice.


Thanks,
Sharath.