Results 1 to 9 of 9

Thread: same again in IE 9

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by DocAElstein View Post
    OK . Think the might do for testing today.....
    last attempt with reply.....

    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




    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

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by DocAElstein View Post
    last attempt with reply.....

    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




    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
    those F***ing *** again !!!

Posting Permissions

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