View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default 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