This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let currentCollation = UILocalizedIndexedCollation.current().sectionTitles | |
| for i in currentCollation.enumerated() { | |
| if i.element == "G" { | |
| print(i.offset + 1, i.element) | |
| } | |
| if i.element == "N" { | |
| print(i.offset + 1, i.element) | |
| } | |
| if i.element == "T" { | |
| print(i.offset + 1, i.element) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Sub Macro() | |
| ' | |
| ' Macro Macro | |
| ' Para usar: 1. Cambia el nombre de la página a Input. 2. Selecciona las filas que quieres transformar. 3. Selecciona los campos que quieres mostrar | |
| ' | |
| ' Acceso directo: CTRL+m | |
| Dim filasATransformar As Range | |
| Set filasATransformar = Application.InputBox("Selecciona un rango de filas a transformar", Type:=8) | |
| Dim columnasAUtilizar As Range |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Julio Fruta | |
| juliofruta |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Dim PreviousValue | |
| Private Sub Worksheet_SelectionChange(ByVal Target As Range) | |
| PreviousValue = Target.Value | |
| End Sub | |
| Private Sub Worksheet_Change(ByVal Target As Range) | |
| If Target.Value <> PreviousValue Then |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "message": "🧍🏽♂️" | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| enum Parenthesis: String { | |
| case open = "(" | |
| case closed = ")" | |
| } | |
| indirect enum Tree { | |
| case character(value: Parenthesis, next: Tree?) | |
| var description: String { | |
| switch self { |
OlderNewer