Results 1 to 1 of 1

Thread: HTML and COde Tags again

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

    HTML and COde Tags again

    Code:
    Sub TestEvaluateVBA2_n1n2n3()Range("H3:H4") = Evaluate("**" & Range("B3:B4").Address & "** " & "&""****""&" & "**** " & Range("C3:C4").Address & "" & "&""****""&" & "" & Range("D3:D4").Address & "")End Sub

    [CODE]Sub TestEvaluateVBA2_n1n2n3()
    Range("H3:H4") = Evaluate("**" & Range("B3:B4").Address & "** " & "&""****""&" & "**** " & Range("C3:C4").Address & "" & "&""****""&" & "" & Range("D3:D4").Address & "")

    Code:
    Sub VBAOnErrorResumeNext()
     On Error Resume Next
    Dim TNominator As Long, RslTwat As Long
    ' Other Code
     Let TNominator = 0
     Let RslTwat = 10 / TNominator ' This will error because of an attempt to divide by zero
     MsgBox Err.Number & " " & Err.Description ' This does give infomation despite that the  exception has been cleared.. wierd and not as one might have expected.
    ' other code
    Dim Rng As Range
     Let Rng.Value = "Anyfink" ' This line should error as we have not assigned any object to rng. ( We cannot therefore asssing a Value to a non existing range
     MsgBox Err.Number & " " & Err.Description
    ' 0ther code
    End Sub
    Last edited by DocAElstein; 03-18-2018 at 02:41 AM.

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 Spreadsheet Test
    By DocAElstein in forum Test Area
    Replies: 3
    Last Post: 09-20-2014, 03:41 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
  •