Change Font using VBA

  • Thread starter Thread starter junx13
  • Start date Start date
J

junx13

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection.AutoFill Destination:=Range 0
Tabbing Issue after macro runs on selected cell 0
change font using conditional formatting 1
Macro for using solver function using visual basic 0
Access How to record date/time when specific field is modified in Access 2007 0
Need help with formula to lookup number based on multiple criteria 1
Generating a reply with the original message included 0
Need halp with pivot table in vba 0

Back
Top