Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Private Sub Highlight_Tree(ByVal highlight_node As Object) ' Parentnode previously declared as node - had to change to avoid type mismatch error. Dim row As Range Dim rngcomments As Range Dim wkscomments As Worksheet Dim n As Object Set wkscomments = ThisWorkbook.Worksheets("Comments") Set rngcomments = wkscomments.Range("Comments") Do Until highlight_node Is Nothing For Each row In rngcomments.Rows Debug.Print row.Columns(1).Value, highlight_node.Key If row.Columns(1).Value = highlight_node.Key Then With highlight_node.Font .Bold = True End With Exit For End If Next row Highlight_Tree highlight_node.Child Set highlight_node = highlight_node.Next Loop End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How do I sort an excel spread of random Hash values in one and I want to most frequently matcing set first||6||38|
|what program/tool is used to create charts like this?||4||33|
|Command button to lock and unlock sheet to protect formulas in Excel||6||25|
|How to always round a decimal up||5||20|