+ Reply to Thread
Results 1 to 2 of 2

Can't change default font with VBA

  1. #1
    Registered User
    Join Date
    01-29-2017
    Location
    Saint Petersburg, Russia
    MS-Off Ver
    2021
    Posts
    16

    Can't change default font with VBA

    I want to change the default font for the document, but when I run the code it says that "method or data member not found" for "Font" word.

    So
    Please Login or Register  to view this content.
    does not work, as well as applying it to individual cells or table as a whole (
    Please Login or Register  to view this content.
    )

    Please let me know hot to change the default font for a document.

    Thank you!

  2. #2
    Registered User
    Join Date
    01-29-2017
    Location
    Saint Petersburg, Russia
    MS-Off Ver
    2021
    Posts
    16

    Re: Can't change default font with VBA

    It looks like using ".Range" word before ".Font" solves the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change the Default Font
    By Seevee in forum Excel General
    Replies: 3
    Last Post: 10-06-2017, 04:01 PM
  2. Change the default font in Excel
    By zanshin777 in forum Excel General
    Replies: 5
    Last Post: 06-15-2017, 01:49 PM
  3. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  4. Any way to change default font for everything?
    By ctenanthe in forum Excel General
    Replies: 1
    Last Post: 05-09-2012, 03:42 PM
  5. [SOLVED] How to change the default font
    By Vicky in forum Excel General
    Replies: 1
    Last Post: 06-05-2006, 03:00 AM
  6. How do I change default font?
    By Zither in forum Excel General
    Replies: 2
    Last Post: 03-09-2005, 03:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1