Results 1 to 1 of 1

Thread: Code in HTML direct

  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10

    Code in HTML direct

    Sub TestEvaluateVBA3_n1n2n3()
    Dim RangeH3H4 As Range, RangeB3B4 As Range, RangeC3C4 As Range, RangeD3D4 As Range
    Set RangeH3H4 = Range("H3:H4")
    Set RangeB3B4 = Range("B3:B4")
    Set RangeC3C4 = Range("C3:C4")
    Set RangeD3D4 = Range("D3:D4")
    RangeH3H4 = Evaluate(" " & RangeB3B4.Address & " " & "&"" ""&" & " " & RangeC3C4.Address & "" & "&"" ""&" & "" & RangeD3D4.Address & "")
    End Sub
    face=Calibri>Sub TestEvaluateVBA3_n1n2n3()
    Dim RangeH3H4 As Range, RangeB3B4 As Range, RangeC3C4 As Range, RangeD3D4 As Range
    Set RangeH3H4 = Range("H3:H4")
    Set RangeB3B4 = Range("B3:B4")
    Set RangeC3C4 = Range("C3:C4")
    Set RangeD3D4 = Range("D3:D4")
    RangeH3H4 = Evaluate(" " & RangeB3B4.Address & " " & "&"" ""&" & " " & RangeC3C4.Address & "" & "&"" ""&" & "" & RangeD3D4.Address & "")
    End Sub




    Stop
    ' ************************************************** *********************
    Dim Barn As String ' To put this years harvest in: Just a long string with variable values in it
    Let Barn = "slProjectNameName is " & slProjectNameName & vbCrLf & _
    "slModuleName is " & slModuleName & vbCrLf & _
    "slProcedureName is " & slProcedureName & vbCrLf & _
    "lnglCurrentModuleLine is " & lnglCurrentModuleLine & vbCrLf & _
    "lnglModuleProcStartLine is " & lnglModuleProcStartLine & vbCrLf & _
    "lnglProcCountLines is " & lnglProcCountLines & vbCrLf & _
    "lnglModuleProcEndLine is " & lnglModuleProcEndLine
    MsgBox Title:="Harvesting stuff", Prompt:="I harvested this stuff. Its in my Barn:" & vbCrLf & vbCrLf & Barn
    End Sub



    Dim Barn As String ' To put this years harvest in: Just a long string with variable values in it
    Let Barn = "slProjectNameName is " & slProjectNameName & vbCrLf & "slModuleName is " & slModuleName & vbCrLf & "slProcedureName is " & slProcedureName & vbCrLf & "lnglCurrentModuleLine is " & lnglCurrentModuleLine & vbCrLf & "lnglModuleProcStartLine is " & lnglModuleProcStartLine & vbCrLf & "lnglProcCountLines is " & lnglProcCountLines & vbCrLf & "lnglModuleProcEndLine is " & lnglModuleProcEndLine
    Debug.Print "I harvested this stuff. Its in my Barn:" & vbCrLf & vbCrLf & Barn
    Stop
    ' ************************************************** *********************
    MsgBox Title:="Harvesting stuff", Prompt:="I harvested this stuff. Its in my Barn:" & vbCrLf & vbCrLf & Barn
    End Sub
    Last edited by DocAElstein; 12-29-2018 at 11:29 PM.

Similar Threads

  1. Replies: 5
    Last Post: 06-10-2019, 10:14 PM
  2. HTML Code Test --post8798
    By DocAElstein in forum Test Area
    Replies: 19
    Last Post: 06-17-2018, 03:02 PM
  3. HTML and COde Tags again
    By DocAElstein in forum Test Area
    Replies: 0
    Last Post: 08-23-2014, 02:28 AM
  4. Function Code for getting Column Letter from Column Number
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-23-2014, 02:27 AM
  5. 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

Posting Permissions

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