Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


.Find method


.Find method

Author
Message
kiranchauhan
kiranchauhan
Forum God
Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)Forum God (464 reputation)

Group: Forum Members
Posts: 2, Visits: 9
Hey, does anyone know if you can use the find method's searchformat = true to look for Findformat.font.underline = True

This is what code i have so far, I'm looking to find only underlined and/or bold cells in column D

Sub finder()
    Sheets("backup").Select
   
    With Application.FindFormat.Font.Underline = True
   
    ActiveSheet.Column("DBigGrin").Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=True).Activate
   
    End With
   
End Sub

I know its not complete, but i was just getting started with it to see if i could get the idea to work.

the code above returns an error message saying "object doesn't support this property or method"

if anyone has used this or knows what I'm doing wrong, it would be an amazing help.

Thanks

GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search