Differences

This shows you the differences between two versions of the page.

--- microsoft_excel:macro_create_sequence [2020/11/15 20:58] – created peter
+++ microsoft_excel:macro_create_sequence [2021/08/04 14:07] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Microsoft Excel - Macro Create Sequence ======
-<code>
-Sub c_CreateSequence()
-    range("A1").Select
-    Selection.EntireColumn.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
-    range("A1").Value = "UNIQUE_ID"
-    range("B1").Select
-    Selection.Copy
-    range("A1").Select
-    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
-        SkipBlanks:=False, Transpose:=False
-    range("A2").Select
-    ActiveCell.FormulaR1C1 = "1"
-    range("A3").Select
-    ActiveCell.FormulaR1C1 = "=R[-1]C+1"
-    range("A3").Select
-    Selection.Copy
-    range("A4:A1908").Select
-    ActiveSheet.Paste
-    Columns("A:A").Select
-    Selection.Copy
-    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
-        :=False, Transpose:=False
-End Sub
-</code>