[RESOLVED] Changing Font Size, Bolding, Italicizing And Underlining In Excel VBA

I have a number of reports that, thanks to the incomparable DKenny, are working like a champ. Now that the "meat and potatoes" are done, I need to "pretty" them up.

I have a two line report heading in A:1 and A:2

How would I make just those cells Bold and Italicized?

(I have other things I need to do, but I figure I can take how ever this is done and use that as guide for the rest of the "prettying" up I need to do.)

VB Code:

With shWorkSheet.Range("A1:A2").Font
    .Bold = True
    .Italic = True
End With

I actually came back here to delete this thread because I figured it out, but, I like your way better so I'm glad you popped in before I waxed this. I was doing

VB Code:

shWorkSheet.Range("A1").Font.Bold = True
    shWorkSheet.Range("A2").Font.Bold = True

Didn't know about the A1:A2 trick.

Cool. :thumb: