make date BOLD

[miker1999]

Hi,
Quick and easy question, I hope.

I am inserting the date on a worksheet using offset and I would lik
the date to be BOLD. Here is my code:

.Offset(0, 4).Value = Date

Help,
Mike R

 

[Robin Hammond]

Mike,

something like this

with cells(1,1),offset(0.4)
.value = date
.font.bold = true
End with

Robin Hammond
www.enhanceddatasystems.com