Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Font using VBA
Hi, if I want to change the font of the entire worksheet from Arial t Arial Unicode MS ? How do I do that? Will this allow me to read doubl byte characters -- junx1 ----------------------------------------------------------------------- junx13's Profile: http://www.excelforum.com/member.php...nfo&userid=562 View this thread: http://www.excelforum.com/showthread.php?threadid=27308 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Font using VBA
What do you mean by "read"? Transfer text from the worksheet into your VBA
code? Or read text files containing double-byte characters? To answer the 1st question I posed, try changing the font for just one cell, then read it into VBA? As far as changing the font, I guess you could select the entire used range and change the font with a single instruction. But there is the issue of styles that are included. You might have to loop through all of them and change their fonts, particularly the Normal style, as that's what's applied to cells that are currently outside the used range but which may become used if more data/formula are added. On Thu, 28 Oct 2004 01:36:22 -0500, junx13 wrote: Hi, if I want to change the font of the entire worksheet from Arial to Arial Unicode MS ? How do I do that? Will this allow me to read double byte characters? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
Highlight entire document and try to change font - won't change. | Excel Discussion (Misc queries) | |||
change display font to actual selected font | Excel Discussion (Misc queries) |