Results 1 to 10 of 20

Thread: HTML Code Test --post8798

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,355
    Rep Power
    10

    Named Ranges and Named Ranges scope. Referencing a named

    Code:
    Dim ilSanityCheck As Integer
    Dim llEndLine As Long
    
    Set olPane = Application.VBE.ActiveCodePane
    olPane.GetSelection Startline:=llSRow, startcolumn:=llSCol, Endline:=llERow, Endcolumn:=llECol
    
    slProcName = olPane.CodeModule.ProcOfLine(llSRow, vbext_pk_Proc)
    llLine1 = olPane.CodeModule.ProcBodyLine(slProcName, vbext_pk_Proc)
    llCountLines = olPane.CodeModule.ProcCountLines(slProcName, vbext_pk_Proc)
    llStartLine = olPane.CodeModule.ProcStartLine(slProcName, vbext_pk_Proc)
    llEndLine = llStartLine + llCountLines - 1
    
    ' Find Dim Line.
    llCompLine1 = llLine1
    
    Do
      slOLine1 = Trim$(olPane.CodeModule.Lines(llCompLine1, 1))
      
      If Left$(slOLine1, 4) = "Dim " Then
        Exit Do
      ElseIf Left$(slOLine1, 6) = "Const " Then
    Last edited by DocAElstein; 02-01-2019 at 02:47 AM.

Similar Threads

  1. Replies: 5
    Last Post: 06-10-2019, 10:14 PM
  2. This is a test Test Let it be
    By Admin in forum Test Area
    Replies: 6
    Last Post: 05-30-2014, 09:44 AM
  3. change table top row to a different colour with html code
    By peter renton in forum Excel Help
    Replies: 2
    Last Post: 02-17-2014, 08:08 PM
  4. Test
    By Excel Fox in forum Den Of The Fox
    Replies: 0
    Last Post: 07-31-2013, 08:15 AM
  5. Test
    By Excel Fox in forum Word Help
    Replies: 0
    Last Post: 07-05-2011, 01:51 AM

Posting Permissions

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