Results 1 to 10 of 10

Array List of Fonts?

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    56

    Array List of Fonts?

    I'm trying to do an arraylist of fonts but I keep getting the error Object variable or with block variable not set. here is my code:


        Dim formatArrayRight(7 To 60) As Font
        Dim act As Integer
        For act = 7 To 60
        formatArrayRight(act) = Range("M" & act).Font
        Next
    Can you create Font arrays?
    Last edited by andrew c.; 08-04-2011 at 01:52 PM.

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