Enbolden Font in This Array only.

[Guanjin Peter]

where do I add the font.bold = true if I want to make this part of the array in bold only?

        rProd.Offset(3, 0).Resize(, 6) = Array("HandOver By:", "", "", "", "", "Received By:")

.Font.Bold = True

 

[Guanjin Peter]

*hadouken*

 

[Jonmo1]

Perhaps..

rProd.Offset(3, 0).Resize(, 6).Font.Bold = True

 

[Norie]

Eh, which part of the array?

 

[Guanjin Peter]

Array("HandOver By:", "", "", "", "", "Received By:")
this part only.

jonmo1: i did tried that but didn't work...

 

[Guanjin Peter]

*hadouken*

 

[Norie]

Peter

I'm sorry but it still isn't clear what part of the array you want to be in bold.

Unless it's the whole array you want in bold.

 

[Guanjin Peter]

yah the whole array.

if this could be done, can I also do the specific data inside the array to be bold also?

like the above, "recevied by:" and "handOver by:" to be bold?

 

[Norie]

Peter

I'm sorry but you've totally lost me know.

First you seem to want to bold the whole array and then you ask about bolding only particular items in it.

Did you try jonmo's code?

 

[Guanjin Peter]

yup, I did, I remember returning an error, but I forgot what specifically was it. Maybe i'll go try again on monday