Results 1 to 11 of 11

Add 1 to font size of entire worksheet

Threaded View

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Add 1 to font size of entire worksheet

    Is there a way to write a macro that will go throught a worksheet and add 1 to each cell's font size used in that worksheet? I have different fonts and sizes on the worksheet so i cant just select all and change it globally.

    my guess is it will looksmilar to this but i am not sure how to do it:

    For Each Worksheet In ActiveWorkbook.Worksheets
    With Cells.Font
    .Size = (current font size) +1
    End With
    Next
    Last edited by PY_; 02-28-2011 at 09:06 AM.

Thread Information

Users Browsing this Thread

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

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