Formatting text in a a cell with selecting it.

[ExcelMonkey]

I have a line of code which puts text in a cell:

Comrng.Offset(-1, 0) = "Title"

If I want to format "Title" with bold, how do I do it
without doing

Comrng.Offset(-1, 0).Select
Selection.Font.Bold

That is, I do not want to select it. Can I wrap the
format function around it?

Comrng.Offset(-1, 0) = Format("Title", ???????)

Can't figure out what to do.

Thanks

 

[arno]

Hi,

Comrng.Offset(-1, 0).Select
Selection.Font.Bold

That is, I do not want to select it.

well, then just don't select it...

Comrng.Offset(-1, 0).Font.Bold

When you're manipulating an object you do not have to select it, this
happens only in the macro recorder because you do it with the mouse.

arno