Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to be able to take a list of the same phrase and assign a
different font to each line. I am trying to see what the text would look like with each font. My problem is I do not know how to refer to each font other than by name. It cant just use selection.font.name=1 and so on. Is there some way to refer to a font other than by name? Thanks Scott Sub font() I = 1 For Each cell In Selection cell.font.Name = I Cells(cell.Row, cell.Column + 1) = cell.font.Name I = I + 1 Next cell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
Cycle Times | Excel Worksheet Functions | |||
2 cycle logarithmic? | Charts and Charting in Excel | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
How can I lengthen the drop down Fonts list to show more fonts at | Excel Discussion (Misc queries) |