Formatting text in a a cell with selecting it.
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
|