Results 1 to 9 of 9

Font and Row Height with multi with or if statements

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    dc
    MS-Off Ver
    Excel 2010
    Posts
    8

    Post Font and Row Height with multi with or if statements

    I am able to change the font size of my text based on location. However, I am unable to change the row size based on the same If Then criteria. I am unsure what I am doing wrong. any suggestions?!

    I keep getting the With object must be user-defined type, Object, or Variant error

     For Each s In Sheets
    
        s.Select
        Cells.Select
       
        With Selection
       
        End With
    
        For Each cll In ActiveSheet.Range("J101:J110")
            If Range("J101") = "Here!" Then
                With Range("A101:A113").FONT
                .Size = 12
                .Name = "Times New Roman"
                .Bold = False
                End With
                
            If Range("J101") = "Here!" Then
                With Range("A101:A113").Row
                    Cells.RowHeight = 15.75
            End With
    
     End If
        End If
       Next
    Next s
     
    End Sub
    #vba pro in training
    Last edited by sas2007; 08-21-2012 at 03:09 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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