Skip to content

Instantly share code, notes, and snippets.

@clockcrockwork
Created September 23, 2021 01:19
Show Gist options
  • Save clockcrockwork/0af15889d74cebf57c61fae9e3c92138 to your computer and use it in GitHub Desktop.
Save clockcrockwork/0af15889d74cebf57c61fae9e3c92138 to your computer and use it in GitHub Desktop.
Name Tags
うえ Range(Selection, Selection.End(xlUp)).Select
うえ Selection.End(xlUp).Select
えr On Error GoTo
かいぎょう nl = Chr(13) & Chr(10)
かうんと Selection.Cells.Count
ぎょう Selection.Areas(1).Rows.Count
ぎょう Cells(Rows.Count, 1).End(xlUp).Row
せtぢc = CreateObject("Scripting.Dictionary")
さいご Cells(Rows.Count, 1).End(xlUp).Row
さいご Cells(1, Columns.Count).End(xlToLeft).Column
さくじょ Selection.ClearContents
した Range(Selection, Selection.End(xlDown)).Select
した Selection.End(xlDown).Select
zj
zk
zl
ひだり Range(Selection, Selection.End(xlToLeft)).Select
ひだり Selection.End(xlToLeft).Select
みぎ Range(Selection, Selection.End(xlToRight)).Select
みぎ Selection.End(xlToRight).Select
れつ Selection.Areas(1).Columns.Count
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment