Results 1 to 2 of 2

Thread: beginning of document word and vba

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2005
    Posts
    83

    beginning of document word and vba

    In my code i am selecting all the text around where text is selected, that is underlined.
    However if the text is at the very start of the document it throws an error,
    what code would i need to insert so that it does this unless/untill it hits the start of the document??

    Here's my code:

    Dim lClr As Long
    Dim rTmp As Range

    Set rTmp = Selection.Range
    lClr = Selection.Font.UnderlineColor

    Do While rTmp.Previous.Font.UnderlineColor = lClr
    rTmp.start = rTmp.start - 1
    Loop

    Do While rTmp.Next.Font.UnderlineColor = lClr
    rTmp.End = rTmp.End + 1
    Loop

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: beginning of document word and vba

    The .Previous with no where to go is the issue. If you use the Words collection and test if your on the
    first word then you can avoid the error.

    VB Code:
    1. If rTmp.Words(1).Start > 1 Then '...
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width