Vb6 writing to excel.

[Wernerh]

Could anyone tell me what is wrong with my statement?

[CODE=vb]WSa1.Cells(17, 3).NumberFormat .Font = Bold[/CODE]
WSa1 is the worksheet name in the Excel book I am writing to, then obviously the cell that needs to be bold.
It does not bold that text. What have I got wrong in here?
Thanks Werner

[prakashsakthivel]

Could anyone tell me what is wrong with my statement?

VB Code:

WSa1.Cells(17, 3).NumberFormat .Font = Bold

WSa1 = is the worksheet name in my excel book I am writing to, then obviously the cell that needs to be bold.
It does not bold that text. What have i got wrong in here?
Thanks Werner

Hi Werneth,

I think you want to format cell content.
The best and easy way to do so is through the Range object.

Let's example

[CODE=vb]'Select cell value as Range

with WSa1
.Range("A12:M12 ").Font.Siz e = 14
.Range("A12:M12 ").Font.Bol d = True
.Range("A12:M12 ").Borders.Colo r = vbBlack
End with[/CODE]

Regards

Prakashsakthive l

[Wernerh]

Hi,

Thank you, that really helps.

Werner